SQL- DWH Developer

Key Responsibilities

• Develop and maintain Python-based applications.
• Design and optimize SQL queries and databases.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Write clean, maintainable, and efficient code.
• Troubleshoot and debug applications.
• Participate in code reviews and contribute to team knowledge sharing.

Qualifications and Required Skills

• Strong proficiency in Python programming.
• Experience with SQL and database management.
• Experience with web frameworks such as Django or Flask.
• Knowledge of front-end technologies like HTML, CSS, and JavaScript.
• Familiarity with version control systems like Git.
• Strong problem-solving skills and attention to detail.
• Excellent communication and teamwork skills.

Good to Have Skills

• Experience with cloud platforms like AWS or Azure.
• Knowledge of containerization technologies like Docker.
• Familiarity with continuous integration and continuous deployment (CI/CD) pipelines

• Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
• At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
• Strong Technical knowledge on SQL databases, MSBI.
• Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
• Well versed with Duck Creek Extract Mapper Architecture
• Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
• Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
• Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
• Understanding of data related to business application areas policy, billing, and claims business solutions
• Minimum 4 to 7 year working experience on Duck Creek Insights product
• Strong Technical knowledge on SQL databases, MSBI
• Preferable having experience in Insurance domain
• Preferable experience in Duck Creek Data Insights
• Experience specific to Duck Creek would be an added advantage
• Strong knowledge of database structure systems and data mining
• Excellent organisational and analytical abilities
• Outstanding problem solver

Immediate Joiners Preferred. Notice Period - Immediate to 30 Days

Interested candidates are requested to email their resumes with the subject line "Application for [Job Title]".

Only applications received via email will be reviewed. Applications through other channels will not be considered.

About Us

adesso India is a dynamic and innovative IT Services and Consulting company based in Kochi. We are committed to delivering cutting-edge solutions that make a meaningful impact on our clients. As we continue to expand our development team, we are seeking a talented and motivated Backend Developer to join us in creating scalable and high-performance backend systems.

Job Description

We are looking for an experienced Backend and Data Developer with expertise in Java, SQL, BigQuery development working on public clouds, mainly GCP. As a Senior Data Developer, you will play a vital role in designing, building, and maintaining robust systems to support our data analytics. This position offers the opportunity to work on complex services, collaborating closely with cross-functional teams to drive successful project delivery.

Responsibilities

• Development and maintenance of data pipelines and automation scripts with Python
• Creation of data queries and optimization of database processes with SQL
• Use of bash scripts for system administration, automation and deployment processes
• Database and cloud technologies
• Managing, optimizing and querying large amounts of data in an Exasol database (prospectively Snowflake)
• Google Cloud Platform (GCP): Operation and scaling of cloud-based BI solutions, in particular
• Composer (Airflow): Orchestration of data pipelines for ETL processes
• Cloud Functions: Development of serverless functions for data processing and automation
• Cloud Scheduler: Planning and automation of recurring cloud jobs
• Cloud Secret Manager: Secure storage and management of sensitive access data and API keys
• BigQuery: Processing, analyzing and querying large amounts of data in the cloud
• Cloud Storage: Storage and management of structured and unstructured data
• Cloud monitoring: monitoring the performance and stability of cloud-based applications
• Data visualization and reporting
• Creation of interactive dashboards and reports for the analysis and visualization of business data with Power BI

Requirements

• Minimum of 4-6 years of experience in backend development, with strong expertise in BigQuery, Python and MongoDB or SQL.
• Strong knowledge of database design, querying, and optimization with SQL and MongoDB and designing ETL and orchestration of data pipelines.
• Expierience of minimum of 2 years with at least one hyperscaler, in best case GCP
• Combined with cloud storage technologies, cloud monitoring and cloud secret management
• Excellent communication skills to effectively collaborate with team members and stakeholders.
• 
  

Nice-to-Have:

• Knowledge of agile methodologies and working in cross-functional, collaborative teams.

Context for the Candidates:

Blockchain engineers are tasked with building secure, scalable, and high-performance decentralized applications. This discussion focuses on how to utilize key technologies—Node.js, Rust, Go, TypeScript, Ethers.js, viem, and Hardhat—in smart contract and blockchain system development, while addressing the practical challenges that arise in such projects.

Key Discussion Points:

• How do you integrate Node.js, Rust, Go, and TypeScript in blockchain-backed applications?

• Discuss the trade-offs between using Rust or Go for performance-critical blockchain services.

• What are the key challenges in ensuring the security and scalability of smart contracts using tools like Ethers.js, viem, and Hardhat?

• How do you approach testing, debugging, and deploying smart contracts in a decentralized environment?

• Share best practices for gas optimization, contract upgradability, and backend scalability.

Evaluation Criteria:

1. Technical Knowledge:

• Strong knowledge of Node.js, Rust, Go, and TypeScript with practical experience in blockchain development.

• Proficiency in Ethers.js, viem, Hardhat, and smart contract lifecycle (development, testing, deployment).

• Understanding of security best practices, performance optimizations, and scalability in decentralized systems.

2. Problem-Solving and Integration Skills:

• How candidates approach integrating smart contract solutions with backend services using Node.js, Rust, Go, and TypeScript.

• Solutions proposed for common challenges in blockchain projects such as gas fees, security vulnerabilities, and system bottlenecks.

3. Experience and Expertise:

• Minimum of 2 years of IT experience, including hands-on development with the specified technologies.

• Practical knowledge of blockchain architecture, consensus mechanisms, and decentralized application deployment.

4. Innovation and Critical Thinking:

• Candidates’ ability to think creatively about system architecture, proposing scalable and secure solutions for blockchain-based applications.

• Discussion on the future potential of blockchain technology and how the tech stack can evolve.

5. Communication and Team Collaboration:

• Clear articulation of technical challenges and how to address them in a team setting.

• Ability to lead or contribute to discussions in a way that encourages collaboration and team-driven problem-solving.

Hey Folks!

We are hiring java developers with Core java-7/8, microservices, springboot, oops, RestAPI and SQL skills.

PYTHON, SQL, TensorFlow, NumPy, SciPy, Pandas

• Expertise in Database Administration on Production Servers with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities in Cloud – AWS / Azure.
• Efficient in Architecting, Configuring, Maintaining, Monitoring, Troubleshooting SQL Servers.
• Strong understanding of SQL database structures, principles, and practice
• Strong experience handling Backups, Restores, Corruption, and Disaster Recovery scenarios.
• Experience in installing and configuring SQL Server databases of different versions.
• Experience in Performance Tuning and Optimization, backups, restores, recovery models. Writing & optimizing SQL statements, partitioning, clustering, HA, DR. Experience in DMV & DDL queries.
• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
• Skilled in working with large volumes of data and loading data from multiple sources.
• Knowledge of reporting and query tools and practices.
• Knowledge of indexes, index management, and statistics.
• Skilled in deploying database change scripts
• Scheduling database backups, taking full and Transaction log backups.
• Automate SQL server tasks (SQL jobs, Windows scripts, etc.)
• Exposure to MySQL will be an added advantage.

Soft skills:

• Mission led. Someone who buys into the mission of a company and the problem they are solving. The company is growing fast and have a tonne of things they need to achieve; they want people that are bought in for the long term and believe in what they’re doing. 
• Pragmatic thinker. You have a structured approach to situations, if you do not know the answer, you’ll know how to find it out. 
• Open to change. You are able to work in a fast-paced environment where priorities can change instantly, and you are able to adjust. 
• Technologist. Someone that is passionate about what they do and experienced in server operating systems and application deployment, configuration, and maintenance. 
• Communication and Presentations skills.

• Set up, manage, automate and deploy AI models in development and production infrastructure.
• Orchestrate life cycle management of AI Models
• Create APIs and help business customers put results of the AI models into operations
• Develop MVP ML learning models and prototype applications applying known AI models and verify the problem/solution fit
• Validate the AI Models
• Make model performant (time and space) based on the business needs
• Perform statistical analysis and fine-tuning using test results
• Train and retrain systems when necessary
• Extend existing ML libraries and frameworks
• Processing, cleansing, and verifying the integrity of data used for analysis 
• Ensuring that algorithms generate accurate user recommendations/insights/outputs
• Keep abreast with the latest AI tools relevant to our business domain

• Bachelor’s or master's degree in Computer Science, Statistics or related field 
• A Master’s degree in data analytics, or similar will be advantageous.
• 3 - 5 years of relevant experience in deploying AI models to production
• Understanding of data structures, data modeling, and software architecture
• Good knowledge of math, probability, statistics, and algorithms
• Ability to write robust code in Python/ R
• Proficiency in using query languages, such as SQL
• Familiarity with machine learning frameworks such as PyTorch, Tensorflow and libraries such as scikit-learn
• Worked with well know machine learning models ( SVM, clustering techniques, forecasting models, Random Forest, etc.)
• Having knowledge in CI/CD for the building and hosting the solutions
• We don’t expect you to be an expert or an AI researcher, but you must be able to take existing models and best practices and adapt them to our environment.
• Adherence to compliance procedures in accordance with regulatory standards, requirements, and policies. 
• Ability to work effectively and independently in a fast-paced agile environment with tight deadlines 
• A flexible, pragmatic, and collaborative team player with an innate ability to engage with data architects, analysts, and scientists.