ETL Developer

Senior ETL Developer

Job Summary:

We are seeking an experienced Senior ETL Developer to design, develop, implement, and maintain robust data integration and data transformation solutions. The ideal candidate will have strong expertise in ETL processes, data warehousing, SQL, and ETL tools such as Informatica, Talend, DataStage, or SSIS. The candidate will collaborate with data architects, business analysts, database administrators, and other technical teams to deliver reliable, scalable, and high-quality data solutions.

Key Responsibilities:

• Design, develop, test, and maintain ETL workflows for extracting, transforming, and loading data from multiple source systems.
• Develop complex SQL queries, stored procedures, functions, and performance-optimized database scripts.
• Build and maintain data pipelines for data warehouses, data marts, and reporting platforms.
• Work with ETL tools such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or Microsoft SSIS.
• Analyze business and technical requirements and translate them into effective ETL solutions.
• Perform data profiling, data cleansing, data validation, reconciliation, and quality checks.
• Optimize ETL jobs, SQL queries, and data processing workflows to improve performance and scalability.
• Troubleshoot data integration issues, resolve production defects, and perform root-cause analysis.
• Develop and maintain technical documentation, mapping specifications, data flow diagrams, and operational procedures.
• Collaborate with data architects, business analysts, developers, QA teams, and stakeholders.
• Support data migration, data conversion, and integration projects across multiple platforms.
• Implement error handling, logging, auditing, and recovery mechanisms for ETL processes.
• Participate in code reviews, unit testing, system integration testing, and deployment activities.
• Monitor scheduled ETL jobs and ensure data availability, accuracy, completeness, and consistency.
• Follow data governance, security, compliance, and development standards.
• Provide technical guidance and mentorship to junior ETL developers.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 14+ years of experience in ETL development, data integration, or data engineering.
• Strong experience with one or more ETL tools, such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or SSIS.
• Advanced knowledge of SQL, including complex joins, subqueries, analytical functions, and query optimization.
• Strong experience with relational databases such as Oracle, SQL Server, PostgreSQL, or Teradata.
• Experience with data warehousing concepts, dimensional modeling, star schemas, snowflake schemas, and slowly changing dimensions (SCD).
• Experience developing complex ETL mappings, workflows, transformations, and reusable components.
• Knowledge of data migration, data quality, data profiling, and data reconciliation techniques.
• Experience with performance tuning and troubleshooting large-volume data processing jobs.
• Familiarity with Unix/Linux shell scripting and job scheduling tools.
• Experience with version control systems such as Git or SVN.
• Strong analytical, problem-solving, communication, and collaboration skills.

Preferred Qualifications:

• Experience with cloud-based data platforms such as AWS, Microsoft Azure, or Google Cloud Platform.
• Knowledge of cloud data warehouses such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics.
• Experience with big data technologies such as Apache Spark, Hadoop, or Kafka.
• Familiarity with Python, PySpark, or other scripting languages for data processing and automation.
• Understanding of CI/CD pipelines, automated testing, and ETL deployment practices.
• Experience with Agile/Scrum methodologies and enterprise data integration projects.
• Knowledge of metadata management, master data management (MDM), and data governance frameworks.

Key Skills:

• ETL Development and Data Integration
• Informatica / DataStage / Talend / SSIS
• Advanced SQL and Database Programming
• Data Warehousing and Data Modeling
• Data Migration and Data Transformation
• ETL Performance Tuning
• Data Quality and Validation
• Unix/Linux Shell Scripting
• Cloud Data Platforms
• Production Support and Troubleshooting
• Technical Documentation
• Team Collaboration and Mentoring

Soft Skills

• Strong analytical and critical-thinking abilities.
• Excellent problem-solving and troubleshooting skills.
• Effective written and verbal communication.
• Ability to work independently and manage multiple priorities.
• Strong attention to detail and commitment to data accuracy.
• Ability to collaborate with cross-functional and distributed teams.

Success Criteria

• Delivery of reliable, scalable, and high-performance ETL pipelines.
• Improved data quality, consistency, and processing efficiency.
• Timely resolution of production issues and data discrepancies.
• Successful delivery of data integration and migration initiatives.
• Compliance with technical standards, data governance, and security requirements.