Full Job Description
Design, develop, and maintain ETL processes to extract data from multiple source systems (databases, APIs, flat files, etc.)
Transform and cleanse data to meet business and technical requirements
Load data into target systems such as data warehouses, data lakes, or BI platforms
Develop and optimize data pipelines for performance, scalability, and reliability
Ensure data quality, integrity, and consistency across systems
Perform data validation, reconciliation, and error handling
Collaborate with business analysts, data architects, and stakeholders to understand data requirements
Troubleshoot and resolve data-related issues and performance bottlenecks
Implement logging, monitoring, and alerting mechanisms for ETL workflows
Maintain technical documentation, data mappings, and workflow design
Oversee ETL pipeline development, execution, and reliability
Ensure data quality, integrity, and consistency across systems
Drive performance optimization and scalability of data workflows
Collaborate with stakeholders to align data solutions with business needs
Govern data processes, compliance, and continuous improvement initiatives
Advanced SQL & Data Transformation
ETL Tools (Informatica / Talend / SSIS / DataStage) Scripting/Programming (Python, Shell)
Data Warehousing Concepts (Dimensional Modeling, Star/Snowflake)