Test Automation Consultant

Infosys Limited; Oakland (CA); Hybrid; USD 85,000 - 122,000; Full time

Benefits offered by this job

Disability Insurance

Health Reimbursement Accounts

Insurance (Accident, Critical Illness,

401(k) plan

Job summary

Infosys in the United States is seeking a Technology Consultant 2 to drive data quality and ETL validation projects within healthcare payer data streams, leveraging AI-driven insights to improve patient outcomes. You will own end-to-end SDLC from requirements to implementation, perform data testing, code reviews, and help teams deploy scalable data platforms such as Databricks or Snowflake.

This role requires strong SQL, Python, PySpark, and BI validation skills, plus collaboration across

Qualifications

• Bachelor's degree or foreign equivalent required.
• Experience in healthcare payer data validation.
• Experience in Claims (837/835) validation.
• Experience in data quality rule definition and threshold validation.
• Experience in reporting and BI validation.
• Experience in data defect management.

Responsibilities

• Document assigned parts of business requirements, in line with guidance provided.
• Facilitate software application design discussions, and document design decisions to guide the technical team.
• Participate in coding and integrate new features or updates into existing applications, focusing on stability.
• Conduct code reviews, changes to the codebase and maintain code repositories.
• Implement test strategies, analyse results, and coordinate bug fixes to uphold quality standards.
• Develop user training programs, documentation, and support frameworks for new software applications.
• Resolve production issues and recommend preventive strategies to enhance system reliability.
• Maintain detailed records of code, testing techniques, and support activities.

Skills

Big data testing

Data quality validation

ETL testing

SQL (advanced)

Python validation scripting

PySpark

Great Expectations/dbt

Education

Bachelor’s degree or foreign equivalent

Tools

Jira

qTest/ALM

Informatica

Azure Data Factory

Power BI

Tableau

Cognos

Job description

Technical Skills 2

Technology|ETL & Data Quality|ETL & Data Quality - ALL

Salary min

85375

Salary max

121938

Overview

The Infosys Healthcare unit is dedicated to transforming the healthcare industry by leveraging cutting-edge AI-driven solutions to simplify complexities and enhance patient experiences. We focus on creating connected ecosystems, optimizing operations, and delivering superior care across all touchpoints. Join us to be a part of a team that is at the forefront of healthcare innovation, driving down costs while improving patient outcomes.

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below:

• 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 towards building software solutions
• Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
• Conduct code reviews, do changes to the codebase and maintain code repositories
• Implement test strategies, analyse results, and coordinate bug fixes to uphold the 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 other similar projects

Your contribution to the team:

• A collaborative spirit and excellent communication skills.
• The ability to handle end to end SDLC phases from requirement gathering to implementation.
• A knack for translating complex requirements into actionable development tasks.
• A passion for design and hands-on coding experience
• A proactive approach to testing, troubleshooting, and refining our applications.
• The ability to work with cross-functional teams and do software integration.

Required Skill and Experience

• Experience in Big data testing and data quality validation.
• Experience in source-to-target validation and reconciliation.
• Experience in ETL and data quality pipeline testing.
• Experience in data quality rule definition and threshold validation.
• Experience in reporting and BI validation.
• Experience in data defect management.
• Experience in advanced SQL including joins, window functions, aggregations, and reconciliation queries.
• Experience in Python validation scripting.
• Experience in PySpark.
• Experience in Pandas.
• Experience in dimensional modeling concepts.
• Experience in slowly changing dimensions (SCD).
• Experience in data pipeline and orchestration concepts.
• Experience in Databricks, Snowflake, Redshift, or Synapse.
• Experience in Power BI, Tableau, or Cognos.
• Experience in Informatica, Talend, Azure Data Factory, or Airflow.
• Experience in Jira and qTest/ALM.
• Experience in data quality frameworks including Great Expectations or dbt tests.
• Experience in data masking and de-identification validation.
• Experience in Healthcare payer data validation.
• Experience in Claims (837/835) validation.
• Experience in Enrollment and eligibility (834) validation.
• Experience in Provider, member, encounter, HEDIS, risk adjustment, and regulatory reporting validation.

Preferred Skill and Experience

• Experience in Healthcare payer platforms.
• Experience in HL7.
• Experience in FHIR.
• Experience in C-CDA.
• Experience in Cloud data platforms.
• Experience in data warehouse modernization.
• Experience in automated data validation frameworks.
• Experience in data quality automation at scale.
• Experience in regulatory reporting validation.
• Experience in quality measures and HEDIS reporting.

Additional Required 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.

Along with competitive pay, as a full-time Infosys employee you are also eligible for the following benefits:

• Long-term/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

About Us

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO

Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.