ETL Testing Consultant

Infosys•Richardson, TX

2d•Onsite

About The Position

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below: I am an ETL Testing Consultant. I am responsible for contributing to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided. I facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions. I participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability. I conduct code reviews, do changes to the codebase and maintain code repositories. I implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards. I develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications. I actively participate in resolving production issues and recommend preventive strategies to enhance system reliability. I maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects. I have a collaborative spirit and excellent communication skills. I have the ability to handle end to end SDLC phases from requirement gathering to implementation. I have a knack for translating complex requirements into actionable development tasks. I have a passion for design and hands-on coding experience. I have a proactive approach to testing, troubleshooting, and refining our applications. I have the ability to work with cross-functional teams and do software integration. I have experience in ETL testing, data warehouse testing, and data migration testing. I have experience in SQL, SparkSQL, data validation, data reconciliation, and database testing. I have experience using Automation Selenium with Python and Shell scripting for automation and data validation. I have experience developing ETL test automation solutions using Python. I have experience with ETL platforms such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks. I have experience validating cloud-based data platforms such as AWS, Azure, Databricks, Snowflake, Redshift, BigQuery, or GCP. I have a Bachelor’s degree or foreign equivalent required from an accredited institution. I am authorized to work for any employer in the United States without employer-based visa sponsorship. I am unable to provide immigration sponsorship for this role now or in the future. I am passionate about AI and eager to make a significant impact. I am part of 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 our clients accelerate growth and unlock business value. Our AI-driven solutions empower financial institutions to make smarter decisions, enhance customer experiences, and achieve operational excellence. Join us to be part of a pioneering team that is at the forefront of financial services transformation. You'll have the opportunity to work with cutting-edge AI technologies, collaborate with industry experts, and contribute to transformative projects across banking, wealth management, and insurance sectors.

Requirements

Experience in ETL testing, data warehouse testing, and data migration testing.
Experience in SQL, SparkSQL, data validation, data reconciliation, and database testing.
Experience using Automation Selenium with Python and Shell scripting for automation and data validation.
Experience developing ETL test automation solutions using Python.
Experience with ETL platforms such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks.
Experience validating cloud-based data platforms such as AWS, Azure, Databricks, Snowflake, Redshift, BigQuery, or GCP.
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.
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.

Nice To Haves

Experience in Finacle mBanking Testing, Capital Markets, Wealth Management, Mortgage, or Financial Services domains.
Good to have experience in BI reporting validation using Power BI, Tableau, Qlik, or MicroStrategy.
Good to have experience with Big Data technologies such as Hadoop, Spark, Hive, and Kafka.
Knowledge in AI-enabled Data Quality and Data Governance solutions.

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