ETL Testing Consultant

Infosys•Quincy, MA

12d•Hybrid

About The Position

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below: The ETL Testing Consultant will be responsible for contributing to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided. They will also facilitate software application design discussions and document design decisions to guide the technical team towards building software solutions. The consultant will participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability. They will conduct code reviews, make changes to the codebase, and maintain code repositories. Additionally, the ETL Testing Consultant will implement test strategies, analyze results, and coordinate bug fixes to uphold software quality standards. They will develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications. The role also involves actively participating in resolving production issues and recommending preventive strategies to enhance system reliability. Finally, the consultant will maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects. The ideal candidate will possess a collaborative spirit and excellent communication skills, with the ability to handle end-to-end SDLC phases from requirement gathering to implementation. A knack for translating complex requirements into actionable development tasks is essential, along with a passion for design and hands-on coding experience. A proactive approach to testing, troubleshooting, and refining applications is also required, as is the ability to work with cross-functional teams and perform software integration. Infosys is a global leader in next-generation digital services and consulting, enabling clients in over 50 countries to navigate their digital transformation. With over four decades of experience, Infosys expertly steers clients through their digital journey by enabling the enterprise with an AI-powered core and agile digital at scale. Their always-on learning agenda drives continuous improvement through building and transferring digital skills, expertise, and ideas from their innovation ecosystem. The Infosys Financial Services unit is a global leader in driving digital transformation for financial institutions, specializing in leveraging advanced technologies such as AI, cloud, and data-led innovation. They empower financial institutions to make smarter decisions, enhance customer experiences, and achieve operational excellence. This role offers 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 Testing, Big Data testing, and BI reports testing.
Experience in SQL query writing, SQL analysis, and data validation.
Experience with Databricks, AWS, and Azure Cloud platforms.
Experience in API testing using REST/SOAP and integrating validations with CI/CD pipelines.
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.

Nice To Haves

Experience in Selenium-Python automation framework development and maintenance.
Experience converting transformations into SQL queries for data validation.

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.