Job Description

Roles & Responsibilities

Job Responsibilities

Step into a dynamic environment where your expertise as an ETL Test Engineer can truly shine. In this role, you will be at the heart of ensuring the quality and reliability of data systems that drive business decisions. You will be collaborating with a talented team of professionals who are committed to innovation and excellence.

Key Responsibilities

Design, develop, and execute ETL test plans to ensure data integrity and performance.
Analyze user stories, data models, DBT transformation logic, and mapping documents to build comprehensive data test cases. Execute end-to-end ETL/Data pipeline testing across multiple layers viz raw, staging, curated, and analytics layers.
Validate data transformations implemented in DBT models, ensuring correctness of joins, aggregations, schemas, and business rules.
Defect Management & Collaboration Identify, reproduce, and document defects using Jira, ensuring proper data-level evidence.
Collaborate closely with Data Engineers, DBT developers, and Cloud teams to understand transformations, data flows, and architecture impacts. Participate actively in Agile ceremonies :stand-ups, grooming, sprint planning, retrospectives.
Quality Process & Contribution: Contribute to data quality processes, validation rules, sampling methodologies, reconciliation checks, regression strategies.
Continuously improve test artifacts, test data, and quality coverage. Stay current with modern data engineering and cloud testing practices.

Required Skills & Qualifications

Strong SQL skills with ability to write complex joins, aggregations, window functions, and data comparisons. Experience testing data warehouses or snowflake. Understanding of DBT (models, seeds, snapshots, lineage).
Exposure to cloud services relevant to data workflows. Experience in API testing (Postman, Swagger, REST/JSON validation).
Familiarity with Gherkin and BDD-style test documentation. Test management experience using Zephyr, Jira. Strong experience in creating test plans, test scenarios, regression packs.
Excellent communication and coordination skills.

Experience

6-8 Years

Skills

Primary Skill: Manual Testing
Sub Skill(s): Manual Testing
Additional Skill(s): JSON, REST APIs, JIRA, Cucumber, Manual Testing, SQL, API Automation, ETL Testing, Postman

About The Company

Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).

Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.