ETL Test Consultant

About the role

Join the Infosys Financial Services unit, a global leader in driving digital transformation for financial institutions. We specialize in leveraging advanced technologies such as AI, cloud, and data-led innovation to help clients accelerate growth and unlock business value. As a Technology Consultant 2, you'll work with cutting-edge AI technologies, collaborate with industry experts, and contribute to transformative projects across banking, wealth management, and insurance sectors.

Responsibilities

• Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided.
• Facilitate software application design discussions and document design decisions to guide the technical team toward building software solutions.
• Participate in coding and integrate new features or updates into existing applications, focusing on maintaining system stability.
• Conduct code reviews, make changes to the codebase, and maintain code repositories.
• Implement test strategies, analyze results, and coordinate bug fixes to uphold software quality standards.
• Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications.
• Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability.
• Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist similar projects.

Requirements

• 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.

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• This position may require relocation and/or travel to work/project location.
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role now or in the future.

Skills

Preferred

• Exposure to automation testing using Selenium-Java or Tosca.
• Experience with Big Data technologies such as Hadoop, Spark, Hive, and Kafka.
• Knowledge of AI-enabled data quality and data governance solutions.
• Experience in Banking, Capital Markets, Wealth Management, or Mortgage domain.

Benefits

• Medical, Dental, Vision, and Life Insurance
• Long-term and Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness, Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off