QA ETL Test Engineer

Role &

Responsibilities:

• Design and implement test strategies for ETL processes and data pipelines.
• Perform data validation, transformation, and reconciliation testing.
• Develop and maintain automated test scripts using Python or PySpark.
• Conduct API testing and validate data exchange between systems.
• Collaborate with developers, data engineers, and business analysts to ensure data quality.
• Manage test data and environments for various testing phases.
• Utilize orchestration tools like Airflow, Jenkins, or Control-M for job scheduling and monitoring.
• Perform EDI file testing and validation.
• Work with cloud services (preferably AWS) for data storage, processing, and testing.
• Use tools like ICEDQ or equivalent for data quality and monitoring.

Required Skills & Experience:

• Strong knowledge of

  ETL Testing

  and

  Test Design

  .
• Proficiency in

  SQL

  for data validation and test scripting.
• Experience with

  Testing Techniques

  and

  Test Planning

  .
• Hands-on experience with

  AWS Services

  or other cloud platforms.
• Familiarity with

  Unix/Linux

  environments and shell scripting.
• Experience in

  API Testing

  and

  Test Data Management

  .
• Knowledge of

  Test Automation

  frameworks and tools.
• Experience with

  ICEDQ

  or similar data quality tools.
• Proficiency in

  ETL Tools

  such as

  Informatica

  ,

  AWS Glue

  , etc.
• Familiarity with

  Job Orchestration Tools

  like

  Airflow

  ,

  Jenkins

  , or

  Control-M

  .
• Experience in

  EDI File Testing

  .

Python

Preferred candidate profile