Data Engineer

Strong experience with SQL and database technologies such as SQL Server, Oracle etc. (Preferably Azure Synapse)

Create and maintain SQL-based database objects, including tables, views, indexes, and triggers. & Write optimized queries and ensuring that the database performs efficiently

Troubleshoot database performance issues and identifying solutions to improve performance

Should be Familiar with data modeling and data integration techniques

Strong ETL development skills using Microsoft SSIS and Microsoft SQL Server

Develop and maintain ETL mappings, workflows, and job schedule

Design, develop and implement ETL solutions to extract, transform and load data from various sources into data warehouse

ETL/ELT development using IICS-CDI (Cloud Data Integration), including experience with IICS Cloud Console and PowerCenter Designer

Monitor ETL jobs to ensure successful completion, identify and resolve errors and performance issues. Troubleshoot and resolve issues with existing ETL processes.

Good understanding of data warehousing concepts, ETL/ELT frameworks, and best practices

Understanding of distributed file systems: HDFS, ADLS etc.

Ensure data quality, integrity, and consistency by performing data validation, cleansing, and enrichment activities

Be able to Work with cross-functional teams to understand business requirements and translate them into technical specifications for ETL development

Experience with version control tools such as Git and follow CICD practice.

Experience with scripting languages such as Python or Shell scripting

Excellent analytical and problem-solving skills, with a keen attention to detail

Ability to work independently and Support Team members in a team-oriented, collaborative environment

Strong communication and interpersonal skills

Familiarity with Agile development methodologies

Full time