Etl Developer

Send your resume at [email protected]

ETL Developer SQL | ETL/ELT | Data Warehousing | Data Pipelines

Company: Spark Techwave InnovationZ Pvt Ltd
Job Type: Full-Time
Experience: 26 Years
Location: Chennai / Remote / Hybrid
Department: Data Engineering / Analytics

Job Summary

Spark Techwave InnovationZ Pvt Ltd is looking for a skilled ETL Developer to design, develop, test, and maintain data extraction, transformation, and loading processes.

The candidate will be responsible for building reliable data pipelines, integrating data from multiple sources, transforming data for reporting and analytics, and ensuring data quality and accuracy. The ideal candidate should have strong knowledge of SQL, ETL tools, data warehousing concepts, and database technologies.

Key Responsibilities

• Design, develop, and maintain ETL/ELT workflows to extract data from multiple sources.
• Build data pipelines to move and transform data between source systems and target databases.
• Develop complex SQL queries, stored procedures, functions, and scripts.
• Perform data cleansing, validation, transformation, and deduplication.
• Integrate data from relational databases, flat files, APIs, and other source systems.
• Develop incremental data loads, full loads, and change data processing where required.
• Implement data quality checks, reconciliation, and error-handling mechanisms.
• Monitor ETL jobs and troubleshoot pipeline failures and performance issues.
• Optimize SQL queries and ETL workflows for performance and scalability.
• Work with data warehouses, data marts, and reporting systems.
• Collaborate with data engineers, data analysts, BI developers, and business teams.
• Maintain technical documentation, source-to-target mappings, and data flow diagrams.
• Support production deployments and resolve data-related incidents.
• Follow data security, access control, and development standards.

Required Skills

• 26 years of hands-on experience in ETL development or data integration.

• Strong knowledge of SQL and relational databases.

• Experience with at least one ETL tool, such as:

• Informatica PowerCenter / IICS

• Talend

• Microsoft SSIS

• IBM DataStage

• Pentaho

• Understanding of ETL/ELT processes and data integration patterns.

• Knowledge of data warehousing concepts, including fact tables, dimension tables, and data marts.

• Experience with data extraction, transformation, loading, and validation.

• Ability to write complex SQL queries, joins, subqueries, and aggregations.

• Knowledge of stored procedures and database performance tuning.

• Experience with data quality checks, error handling, and job scheduling.

• Understanding of relational database concepts and data modeling.

• Strong analytical, debugging, and problem-solving skills.

Good to Have

• Experience with cloud data platforms such as AWS, Microsoft Azure, or Google Cloud.
• Knowledge of cloud ETL services such as AWS Glue, Azure Data Factory, or Google Cloud Data Fusion.
• Experience with Python or PySpark.
• Knowledge of Snowflake, Databricks, Amazon Redshift, or Google BigQuery.
• Familiarity with Apache Airflow or other workflow orchestration tools.
• Understanding of CDC (Change Data Capture) and incremental loading.
• Experience with Git, CI/CD, and version control.
• Knowledge of dimensional modeling and slowly changing dimensions (SCD).
• Experience with data governance, metadata, and data lineage.
• Familiarity with Agile/Scrum methodologies.

Education

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Candidate Profile

• Strong hands-on experience building and supporting ETL pipelines.
• Good understanding of data movement and transformation processes.
• Ability to troubleshoot complex data issues independently.
• Strong SQL and analytical skills.
• Ability to collaborate with cross-functional technical teams.
• Good communication and technical documentation skills.

Key Skills for Naukri

ETL Developer, ETL, ELT, SQL, Data Integration, Data Warehousing, Data Pipelines, Informatica, Informatica PowerCenter, IICS, Talend, SSIS, IBM DataStage, Pentaho, Stored Procedures, Data Transformation, Data Migration, Data Quality, Data Modeling, Python, PySpark, Snowflake, Azure Data Factory, AWS Glue, Databricks, Apache Airflow, CDC

Suggested Naukri Job Titles

• ETL Developer
• ETL Engineer
• Data Integration Developer
• ETL SQL Developer
• Data Warehouse Developer
• Informatica Developer
• SSIS Developer
• Talend Developer
• IBM DataStage Developer
• Cloud ETL Developer

Send your resume at [email protected]