Participate actively in Sprint Planning to analyze user stories, define acceptance criteria, and estimate testing efforts (story points).
Attend Daily Stand-ups to report testing progress, blockages, and data dependencies.
Engage in Backlog Grooming and Sprint Retrospectives to continuously improve team processes and Data Migration / ETL testing workflows.
Proactively collaborate with developers and data engineers for early testing and rapid defect resolution.
Track, manage, and log defects throughout the defect lifecycle using tools like Service Now, Jira or Azure DevOps.
Review Source-to-Target Mapping (STM) documents and business rules to design robust test scenarios.
Write and execute complex SQL queries for data verification, counts, and reconciliation between source systems, staging areas, and data warehouses/marts.
Validate data transformations, aggregations, filtering logic, and boundary conditions.
Perform data integrity, data truncation, NULL-value handling, and duplicate checks.
Build, maintain, and execute automated ETL test scripts using frameworks like Pytest, Python, or Java.
Integrate testing routines within CI/CD pipelines (Jenkins, Azure DevOps, or GitHub Actions).
Experience: 8+ years of hands-on experience in ETL/Data Warehouse testing and backend data validation.
Agile Knowledge: Proven experience working in an Agile/Scrum software development lifecycle.
Database & SQL: Advanced SQL querying skills across relational databases (SQL Server, Oracle, PostgreSQL) or cloud platforms (GCP, Snowflake, Databricks, AWS/Azure).
ETL Tools: Familiarity with enterprise ETL tools (Informatica, SSIS, Talend, or AWS Glue) or cloud data processing frameworks.
Soft Skills: Strong analytical, communication, and problem-solving abilities to bridge technical gaps with business stakeholders.
Scripting: Basic to intermediate programming skills in Python or Java for test automation
Lead a team of data/ETL testers
Test strategy & planning
Test reporting & governance
Participate actively in Sprint Planning to analyze user stories, define acceptance criteria, and estimate testing efforts (story points).
Attend Daily Stand-ups to report testing progress, blockages, and data dependencies.
Engage in Backlog Grooming and Sprint Retrospectives to continuously improve team processes and Data Migration / ETL testing workflows.
Proactively collaborate with developers and data engineers for early testing and rapid defect resolution.
Track, manage, and log defects throughout the defect lifecycle using tools like Service Now, Jira or Azure DevOps.
Review Source-to-Target Mapping (STM) documents and business rules to design robust test scenarios.
Write and execute complex SQL queries for data verification, counts, and reconciliation between source systems, staging areas, and data warehouses/marts.
Validate data transformations, aggregations, filtering logic, and boundary conditions.
Perform data integrity, data truncation, NULL-value handling, and duplicate checks.
Cutover and production migration validation
Build, maintain, and execute automated ETL test scripts using frameworks like Pytest, Python, or Java.
Integrate testing routines within CI/CD pipelines (Jenkins, Azure DevOps, or GitHub Actions).
Experience: 8+ years of hands-on experience in ETL/Data Warehouse testing and backend data validation.
Agile Knowledge: Proven experience working in an Agile/Scrum software development lifecycle.
Database & SQL: Advanced SQL querying skills across relational databases (SQL Server, Oracle, PostgreSQL) or cloud platforms (GCP, Snowflake, Databricks, AWS/Azure).
ETL Tools: Familiarity with enterprise ETL tools (Informatica, SSIS, Talend, or AWS Glue) or cloud data processing frameworks.
Soft Skills: Strong analytical, communication, and problem-solving abilities to bridge technical gaps with business stakeholders.
Scripting: Basic to intermediate programming skills in Python or Java for test automation
BE/MCA
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Zensar stands out as a premier technology consulting and services company, embracing an ‘experience-led everything’ philosophy. We are creators, thinkers, and problem solvers passionate about designing digital experiences that are engineered into scale-ready products, services, and solutions to deliver superior engagement to high-growth companies. This full lifecycle capability – from experience to engineering to engagement – is what makes us unique. This integrated approach also means that we harness the power of technology, creativity, and insight to deliver impact — ensuring our work focuses not just on technology but also on the people who use it.
Part of the $4.4 billion RPG Group, Zensar is headquartered in Pune, India. Our 10,000+ employees work across 30+ locations worldwide, including Seattle, Princeton, Cape Town, London, Singapore, and Mexico City. As an organization, we are diverse and multi-dimensional and unite across geographies and skill sets to deliver products and services that are value-driven, environmentally conscious, and human-centered.
To know more, visit us at www.zensar.com.
