ETL + QA Engineer

Role Overview:

ETL + QA Engineer

ETL testing

QA methodologies

Key Responsibilities:

ETL Testing:

• Validate ETL workflows, data transformations, and data migration processes.
• Perform data integrity checks across multiple databases (SQL, NoSQL, Data Lakes).
• Verify data extraction, transformation, and loading (ETL) processes from source to destination.
• Write and execute SQL queries to validate data accuracy and consistency.
• Identify and report issues related to data loss, truncation, and incorrect transformations.
  

Quality Assurance:

• Develop, maintain, and execute test cases, test plans, and test scripts for ETL processes and applications.
• Perform manual and automation testing for APIs, UI, and backend systems.
• Conduct functional, integration, system, and regression testing.
• Utilize API testing tools (Postman, RestAssured) to validate endpoints and data responses.
• Automate test cases using Selenium, Python, or any other scripting language.
• Participate in performance and scalability testing for ETL jobs.
  

CI/CD & Automation: [ Preferrable ]

• Implement automation frameworks for ETL testing.
• Integrate tests within CI/CD pipelines using Jenkins, GitHub Actions, or Azure DevOps.
• Collaborate with developers and data engineers to improve testing strategies and defect resolution.
  

Required Skills & Experience:

Technical Skills:

• Strong experience in ETL Testing and Data Validation.
• Proficiency in SQL, PL/SQL for complex queries and data verification.
• Hands-on experience with ETL tools like Informatica, Talend, SSIS, or Apache Nifi.
• Experience in API Testing (Postman, RestAssured, SoapUI).
• Knowledge of automation tools (Selenium, Python, Java, or C#).
• Familiarity with cloud platforms (AWS, GCP, Azure) and data warehousing solutions (Snowflake, Redshift, BigQuery).
• Experience working with CI/CD pipelines and Git-based workflows.
• Knowledge of scripting languages (Python, Shell, or PowerShell) is a plus.
  

Soft Skills:

• Strong analytical and problem-solving skills.
• Excellent communication and documentation skills.
• Ability to work in an Agile/Scrum environment.
• Strong collaboration skills to work with cross-functional teams.
  

Preferred Qualifications:

• Bachelor’s/Master’s degree in Computer Science, IT, or related field.
• 4-7 years of experience in ETL Testing, QA.
• Certifications in ISTQB, AWS, Azure, or any relevant ETL tool is a plus.