ETL Developer

We are looking for an ETL Developer with solid experience in building, optimizing, and maintaining data integration workflows, along with strong testing skills to ensure data accuracy, integrity, and performance. The ideal candidate will be able to develop ETL pipelines, validate data transformations, and collaborate with business and QA teams to deliver reliable data solutions. Key Responsibilities: Design, develop, and maintain ETL processes for extracting, transforming, and loading data from multiple sources into target systems. Work closely with business analysts and data architects to translate business requirements into technical solutions. Write and optimize SQL queries for complex data transformations and validations. Conduct unit testing, system testing, and integration testing of ETL workflows to ensure data accuracy and completeness. Create and maintain technical documentation, including data flow diagrams, mapping documents, and transformation rules. Identify and resolve performance bottlenecks in ETL processes. Collaborate with QA teams to prepare and execute ETL test cases, track defects, and verify fixes. Support data migration projects and ensure compliance with data governance and security standards. Required Skills & Experience: Bachelor’s degree in Computer Science, Information Technology, or related field. 5+ years of experience in ETL development using tools like Informatica, Talend, SSIS, DataStage, or Pentaho. Strong SQL skills for data manipulation, validation, and performance tuning. Experience in ETL testing, including data reconciliation and regression testing. Good understanding of data warehousing concepts, dimensional modeling, and ETL best practices. Familiarity with defect tracking tools (e.g., JIRA, HP ALM). Strong problem-solving, debugging, and analytical skills. Preferred Qualifications: Experience with cloud-based ETL platforms (AWS Glue, Azure Data Factory, Google Dataflow, Snowflake). Exposure to automation testing tools for ETL validation (e.g., QuerySurge, Python-based scripts). Knowledge of big data tools (Hadoop, Spark) is a plus. Experience working in Agile/Scrum environments.

#J-18808-Ljbffr