Senior Technical Quality Assurance Engineer

Publicis Groupe Holdings B.V; Bengaluru; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Epsilon is hiring for a QA/Test Engineering role focused on ETL and Data Warehouse testing in Bengaluru. You will validate data accuracy across source, ETL and target layers, and work with stakeholders to ensure data integrity in a dynamic, cloud-enabled environment.

The role requires strong SQL, experience with STLC, and familiarity with Azure DevOps or similar tools. You will collaborate with analytics, engineering and business teams to ensure high-quality data products and timely delivery.

Qualifications

• 5+ years of Quality Assurance experience in IT projects, including ETL and Data Warehouse testing.
• Strong knowledge of ETL concepts, data warehousing architecture, and data marts.
• Advanced SQL proficiency for data validation.
• Experience with STLC and data-centric testing methodologies.
• Experience with test management and defect management tools.
• Able to work in Agile or hybrid delivery models.
• Excellent analytical, problem-solving, and communication skills.
• Experience with test automation and scripting languages.
• Experience with Azure DevOps / TFS / VSTS.
• Exposure to data quality reporting, test metrics and dashboards.

Responsibilities

• Perform end-to-end ETL and Data Warehouse testing to ensure data accuracy, completeness and consistency.
• Validate data aggregation, marts, and dimensional models using SQL and data analysis techniques.
• Create, manage and maintain test data for functional, integration and regression testing.
• Translate business requirements into effective data validation test scenarios.
• Execute complex SQL queries for reconciliation, profiling and defect analysis.
• Review test cases, SQL scripts and validation logic for quality standards.
• Contribute to STLC activities including planning, execution, defect tracking and reporting.
• Estimate QA effort, identify risks and support test planning and scheduling.
• Use test management and defect tracking tools to report metrics and progress.
• Mentor junior testers and provide technical guidance.

Skills

ETL testing

Data Warehouse testing

SQL

STLC

Data quality

Agile/hybrid delivery

Test automation

Azure DevOps

Tools

Azure DevOps

TFS

VSTS

Job description

Overview

About Business Unit:

Platform Services specializes in the implementation, management and evolution of Custom and PeopleCloud solutions, offering end-to-end support for clients. Our team of experts handles platform setup, ongoing management, and strategic enhancements, ensuring that our solutions adapt to changing business needs. From loyalty programs to digital activation, our platforms empower clients to implement campaigns, generate insights, and streamline business activities, all with a focus on seamless integration and continuous improvement. By collaborating with client partners and strategy teams, we create impactful campaigns tailored to each client’s unique objectives.

Who we are looking for

At Epsilon, we run on our people’s ideas. It's how we solve problems and exceed expectations. Our team is now growing, and we are on the lookout for skilled individuals who always reset a higher standard by constantly challenging themselves and are experts in building customized solutions in the digital marketing space.

So, are you someone who remains responsible for the quality of specifications and standards. Do you like helping with planning and implementation of strategies to ensure the highest quality? Then you could be exactly who we are looking for.

What you’ll do:

• Software Quality Assurance. Testing, a crucial component of Software development life cycle
• Responsible for highest quality project/Product deliverables packed in dynamic environment
• Communication with different Stakeholders
• Opportunity to work on latest cloud technologies
• Collaboration with different Technical and Business teams

Responsibilities

• Perform end-to-end ETL and Data Warehouse testing, ensuring data accuracy, completeness, and consistency across source, transformation, and target layers.
• Validate data aggregation, marts, and dimensional models using advanced SQL and data analysis techniques.
• Create, manage, and maintain test data to support functional, integration, and regression testing.
• Analyze business requirements and translate them into effective data validation test scenarios.
• Execute complex SQL queries for source-to-target reconciliation, data profiling, and defect analysis.
• Review test cases, SQL scripts, and validation logic to ensure alignment to quality standards before peer reviews.
• Actively participate in the Software Testing Life Cycle (STLC), including test planning, execution, defect tracking, and reporting.
• Estimate QA effort, identify risks, and provide input for test planning and scheduling.
• Use test management and defect tracking tools to manage test execution and report test metrics.
• Mentor and guide junior testers, providing technical direction and best-practice guidance.
• Collaborate with Business, Development, and Architecture teams to resolve data quality issues and clarify requirements.
• Contribute to continuous improvement initiatives in testing processes, data quality practices, and automation adoption.
• Ability to manage multiple priorities in a fast-paced, dynamic environment.

Qualifications

• Minimum 5+ years of Quality Assurance experience in IT projects, with at least 3+ years of hands-on ETL and Data Warehouse testing.
• Strong knowledge of ETL concepts, data warehousing architecture, aggregation logic, and data marts.
• Advanced SQL proficiency for data validation and analysis.
• Solid experience in test data creation, data analysis, and data validation techniques.
• Solid understanding and hands-on experience with STLC and data-centric testing methodologies.
• Experience working with test management and defect management tools.
• Strong analytical, problem-solving, and communication skills.
• Ability to think end-to-end from a business and data flow perspective.
• Experience with test automation and scripting languages.
• Working knowledge of Azure DevOps / TFS / VSTS or similar defect management tools.
• Exposure to data quality reporting, test metrics, and dashboards.
• Experience working in Agile or hybrid delivery models.

Additional Information

Epsilon is a global data, technology and services company that powers the marketing and advertising ecosystem. For decades, we've provided marketers from the world's leading brands the data, technology and services they need to engage consumers with 1 View, 1 Vision and 1 Voice. 1 View of their universe of potential buyers. 1 Vision for engaging each individual. And 1 Voice to harmonize engagement across paid, owned and earned channels.

Epsilon's comprehensive portfolio of capabilities across our suite of digital media, messaging and loyalty solutions bridge the divide between marketing and advertising technology. We process 400+ billion consumer actions each day using advanced AI and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Epsilon is a global company with more than 9,000 employees around the world.

Our pillars aren't just words. They're how we show up every day.

• People centricity: We focus on employee well-being in an environment where colleagues truly care about each other.
• Collaboration: We work together, support one another, and collectively achieve goals.
• Growth: There are endless opportunities for growth through learning, development and career advancement.
• Innovation: We drive progress through cutting-edge solutions and forward-thinking approaches.
• Flexibility: We've created a balance between work and personal life, and we encourage adaptability to solve problems creatively.

Our values guide us to create value for our clients, our people and consumers.

• Act with integrity
• Work together to win together
• Innovate with purpose
• Respect all voices
• Empower with accountability

These pillars and values are our foundation—shaping our culture, guiding our decisions, and uniting us in common purpose.

Epsilon is an Equal Opportunity Employer. Epsilon is committed to promoting diversity, inclusion, and equal employment opportunities by using reasonable efforts to attract, recruit, engage and retain qualified individuals of all ethnicities and backgrounds, including, but not limited to, women, people of color, LGBTQ individuals, people with disabilities and any other underrepresented groups, traits or characteristics.