Senior ETL Developer

Overview

Senior ETL Developer responsible for designing, developing, testing, and optimizing data integration pipelines and data warehousing solutions.

What you'll do

• Analyze data requirements and design extraction, transformation, and loading methods.
• Perform source-system analysis and develop extract logic.
• Design, implement, and expand data pipelines.
• Investigate ETL pipeline issues and perform data comparison checks.
• Write SQL, Unix shell, and Python scripts for testing and automation.
• Prepare high- and low-level design documents and test cases.
• Coach team members and implement development best practices.

What you'll need

• 4–6 years of development experience in a data warehousing environment.
• Strong experience with Informatica PowerCenter, Oracle, MySQL, Snowflake, and Unix shell scripting.
• Experience with data modelling and data warehousing concepts.
• Hands-on experience with PL/SQL, SQL, and SQL query tuning.
• Ability to write complex Unix shell and Python scripts.
• Knowledge of data analysis, transformation, metadata management, and data security and privacy.
• Experience designing ETL solutions for data warehouse projects.

Nice to have

• Exposure to Matillion, Snowflake OpenFlow, Kafka Streaming, or Mulesoft.
• Experience with CDC environments, Qlik Replicate, big data, APIs, or cloud data integration tools.
• Knowledge of CSV, API, XML, JSON, and AVRO file types.

Details

• Location: Chennai, India.