ETL Test Consultant: Data Quality & Automation Engineer

Infosys; Charlotte (NC); On-site; USD 95,000 - 130,000; Full time

Job summary

Infosys invites applications for a Technology Consultant 2 role focused on ETL testing, data quality, and data warehouse validation. You will contribute to end-to-end ETL projects, document requirements, and collaborate with cross-functional teams to ensure high data integrity and reliable data pipelines.

The role emphasizes hands-on testing, automation using Python or Shell, and active participation in Agile delivery.

Qualifications

• Experience in ETL testing, data quality, data warehouse testing, and data migration testing.
• Experience in ETL, database, and Selenium Python testing.
• Experience in SQL query writing and Unix commands.
• Experience in end-to-end ETL testing, including data migration, conversion, and data quality checks.
• Experience validating source-to-target mappings, transformation rules, data lineage, and business logic.
• Experience with data warehousing concepts including facts, dimensions, star schema, and SCD validations.
• Experience supporting QA release cycles, defect reporting, and defect resolution.
• Experience developing automation solutions using Python or Shell scripting for ETL and data validation activities.
• Experience preparing test strategies, test cases, test execution, result analysis, and validation documentation.
• Experience collaborating with business, development, data engineering, production support, and change management teams.
• Experience working in Agile delivery environments.
• Ability to translate business requirements into technical solutions and communicate clearly.

Responsibilities

• Contribute to requirements elicitation by documenting parts of business requirements.
• Facilitate software design discussions and document design decisions for the technical team.
• Participate in coding and integrate features into applications while maintaining stability.
• Conduct code reviews and maintain code repositories.
• Implement test strategies, analyze results, and coordinate bug fixes.
• Develop user training programs, documentation, and support frameworks for new software.
• Resolve production issues and suggest preventive strategies for reliability.
• Maintain detailed records of code, testing techniques, and support activities.

Skills

ETL testing

Data quality

Data warehouse testing

Data migration testing

SQL

Unix commands

Python scripting

Agile

End-to-end ETL

Data mapping validation

Education

Bachelor’s degree or foreign equivalent

Three years of progressive experience in lieu of education

Tools

Selenium testing

Python

Shell scripting

Hadoop

Spark

Hive

Kafka

Job description

Infosys invites applications for a Technology Consultant 2 role focused on ETL testing, data quality, and data warehouse validation. You will contribute to end-to-end ETL projects, document requirements, and collaborate with cross-functional teams to ensure high data integrity and reliable data pipelines.

The role emphasizes hands-on testing, automation using Python or Shell, and active participation in Agile delivery.