Senior ETL Developer

Position: Senior ETL Developer

Experience: 11+ Years

Job Summary

We are seeking a highly experienced Senior ETL Developer with 11+ years of hands-on experience in designing, developing, optimizing, and maintaining enterprise-scale ETL/ELT solutions. The ideal candidate should possess strong expertise in data integration, data warehousing, SQL, cloud-based data platforms, and modern ETL tools. The candidate will collaborate with business stakeholders, data architects, and development teams to deliver scalable, high-performance data pipelines that support business intelligence, analytics, and reporting initiatives.

Key Responsibilities

• Design, develop, implement, and maintain robust ETL/ELT pipelines for enterprise data integration projects.
• Analyze business requirements and convert them into scalable ETL solutions.
• Develop data extraction, transformation, and loading processes from multiple structured and unstructured data sources.
• Build and optimize data warehouse solutions using dimensional modeling (Star Schema, Snowflake Schema).
• Perform complex data transformations, cleansing, validation, profiling, and reconciliation.
• Develop reusable ETL frameworks and metadata-driven solutions.
• Optimize SQL queries, stored procedures, views, functions, and database performance.
• Ensure data quality, integrity, consistency, and governance across enterprise systems.
• Collaborate with Data Engineers, BI Developers, Architects, and Business Analysts.
• Troubleshoot ETL failures and production issues while ensuring timely resolution.
• Implement CI/CD pipelines for ETL deployments and version control best practices.
• Create technical documentation, data mapping documents, and operational runbooks.
• Mentor junior developers and participate in architecture and design discussions.
• Support Agile/Scrum development methodology.

Required Technical Skills

ETL Tools

• Informatica PowerCenter
• Informatica IICS (Cloud Data Integration)
• SSIS
• Talend
• IBM DataStage
• Azure Data Factory (ADF)
• AWS Glue
• Matillion
• dbt (Good to Have)

Databases

• Oracle
• SQL Server
• PostgreSQL
• MySQL
• DB2
• Snowflake
• Teradata
• Amazon Redshift
• Google BigQuery

Programming & Query Languages

• Advanced SQL
• PL/SQL
• T-SQL
• Python
• Shell Scripting (Unix/Linux)
• PowerShell (Preferred)

Cloud Platforms

• AWS
• Microsoft Azure
• Google Cloud Platform (Google Cloud Platform)

Data Warehouse Concepts

• Data Warehousing
• ETL/ELT
• Data Modeling
• Star Schema
• Snowflake Schema
• Slowly Changing Dimensions (SCD Types 1, 2 & 3)
• Fact & Dimension Tables
• CDC (Change Data Capture)
• Incremental Data Loads

Big Data & Modern Technologies

• Apache Spark
• PySpark
• Hadoop
• Kafka
• Delta Lake
• Databricks

Version Control & DevOps

• Git
• GitHub
• GitLab
• Bitbucket
• Jenkins
• Azure DevOps
• CI/CD Pipelines

Reporting & BI

• Power BI
• Tableau
• SSRS
• Business Objects

Required Qualifications

• Bachelor''s or Master''s degree in Computer Science, Information Technology, Engineering, or a related field.
• 11+ years of professional experience in ETL development and enterprise data integration.
• Strong expertise in SQL performance tuning and database optimization.
• Extensive experience working with enterprise Data Warehouse environments.
• Experience integrating data from ERP, CRM, APIs, flat files, XML, JSON, and cloud applications.
• Strong understanding of SDLC, Agile, and DevOps practices.
• Excellent analytical, debugging, and problem-solving skills.
• Strong communication and stakeholder management abilities.

Preferred Skills

• Experience with Snowflake, Databricks, AWS Glue, Azure Data Factory, or Google Cloud Data Services.
• Hands-on experience with Airflow or enterprise job scheduling tools such as Control-M or Autosys.
• Knowledge of Data Governance, Data Quality, and Master Data Management (MDM).
• Experience working with REST APIs and cloud-native data integration.
• Familiarity with data lake architectures and real-time data processing.
• Relevant certifications in AWS, Azure, Google Cloud Platform, Informatica, or Snowflake are a plus.