Senior Data Engineer | SSIS | SQL Server | Informatica | ETL & BI Solutions

Engineering graduate with over 10 years of professional experience in designing and developing end-to-end Business Intelligence (BI) and ETL solutions. Skilled in Microsoft SQL Server, SSIS, Informatica, Matillion, and data integration across multiple domains including Healthcare, Casino Gaming, Education, Retail, and Supply Chain.

Key Highlights:

9+ years of experience in Microsoft SQL Server and SSIS, with strong proficiency in T-SQL (DDL, DML, DCL), stored procedures, functions, views, triggers, and performance tuning.

Hands-on expertise in Informatica ETL development and performance optimization of mappings and sessions.

Experience in ETL development using Matillion and data validation during Teradata to Snowflake migrations.

Involved in designing, developing, and maintaining data pipelines using SSIS for extracting and transforming data from diverse heterogeneous sources.

Coordinated with source system owners for ETL monitoring and issue resolution, including reprocessing failed records and loading missing dimension data.

Proficient in using Control-M for job scheduling and executing UNIX commands to manage data loads into Teradata.

Basic working knowledge of Power BI and SSRS for data visualization and reporting.

Played a Team Lead role, mentoring junior ETL developers and collaborating with application teams to align database procedures and business requirements.

Strong understanding of data warehousing concepts, dimensional modeling, and enterprise data management best practices.

Work Terms

40 hours/week.