ETL Developer

Key Responsibilities

1. Design, develop, and maintain scalable ETL/ELT pipelines using SSIS and Informatica PowerCenter.
2. Develop, optimize, and manage SQL Server databases, including complex queries, stored procedures, and performance tuning.
3. Build and maintain data pipelines using AWS services such as S3, Glue, and Lambda.
4. Develop efficient and reusable Python scripts for data processing and automation.
5. Manage source code using Git and follow version control best practices.
6. Ensure data quality, validation, and consistency across platforms.
7. Support reporting and analytics requirements using enterprise reporting tools.
8. Monitor, troubleshoot, and enhance production data workflows.

Mandatory Skills

✅ SQL Server & T-SQL (Performance Tuning)

✅ SSIS (SQL Server Integration Services)

✅ Informatica PowerCenter

✅ Python Development

✅ AWS Data Services (S3, Glue, Lambda, etc.)

✅ Git Version Control

✅ Data Warehousing & ETL Concepts

Candidate Requirements

1. Strong hands-on ETL development experience.
2. Good understanding of data warehousing architecture.
3. Excellent problem-solving and debugging skills.
4. Experience working in enterprise-scale data environments.