The Senior Associate QA manages ETL and BI testing, develops test strategies, validates data and reports, and mentors a team of testers.
Key Responsibilities:
ETL & BI Testing:
- Manage the testing of ETL processes, data pipelines, and BI reports to ensure accuracy and reliability.
- Develop and execute test strategies, test plans, and test cases for data validation.
- Perform data reconciliation, transformation validation, and SQL-based testing to ensure data correctness.
- Validate reports and dashboards built using BI tools (Power BI, Tableau).
- Automate ETL testing where applicable using Python, Selenium, or other automation tools.
- Identify and log defects, track issues, and ensure timely resolution.
- Collaborate with business stakeholders to understand data requirements and reporting needs.
- Assist in documenting functional and non-functional requirements for data transformation and reporting.
- Support data mapping, data profiling, and understanding business rules applied to datasets.
- Participate in requirement-gathering sessions and provide inputs on data validation needs.
Required Skills & Experience:
- 6-8 years of experience in ETL, Data Warehouse, and BI testing.
- Strong experience with SQL, data validation techniques, and database testing.
- Hands-on experience with ETL tools (Informatica, Talend, SSIS, or similar).
- Proficiency in BI tools like Power BI, Tableau for report validation.
- Good knowledge of data modeling, star schema, and OLAP concepts.
- Mentor a team of ETL/BI testers and provide guidance on testing best practices.
- Coordinate with developers, BAs, and business users to ensure end-to-end data validation.
- Define QA processes, best practices, and automation strategies to improve testing efficiency.
- Experience in data reconciliation, transformation logic validation, and data pipeline testing.
- Experience in Insurance domain is an added advantage.
- Automation skills for data and report testing (Python, Selenium, or ETL testing frameworks) are a plus.
- Experience in understanding and documenting business & data requirements.
- Ability to work with business users to gather and analyze reporting needs.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management abilities.
- Experience with Agile/Scrum methodologies and working in a cross-functional team.
Preferred Qualifications:
- Experience in cloud-based data platforms (AWS, Azure, GCP) is a plus.
- ISTQB or equivalent certification in software testing is preferred.
Top Skills
AWS
Azure
Bi
ETL
GCP
Informatica
Power BI
Python
Selenium
SQL
Ssis
Tableau
Talend
Similar Jobs at MassMutual India
Big Data • Fintech • Information Technology • Insurance • Financial Services
The role involves executing automated and performance testing, collaborating with QA and development teams, identifying issues, and leveraging technical QA tools.
Top Skills:
AgileApi TestingApp DynamicsConfluenceData AnalyticsData Warehouse TestingDevOpsJIRALoad RunnerNew RelicPerformance CenterSite ScopeWeb Testing
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Senior Architect will oversee technical deliverables, mentor developers, engage in design work, and implement best practices in data engineering.
Top Skills:
Data EngineeringSoftware DevelopmentSolution Architecture
Big Data • Fintech • Information Technology • Insurance • Financial Services
The role involves executing automated and performance testing, collaborating with QA and development teams, identifying issues, and leveraging technical QA tools.
Top Skills:
AgileApi TestingApp DynamicsConfluenceData AnalyticsData Warehouse TestingDevOpsJIRALoad RunnerNew RelicPerformance CenterSite ScopeWeb Testing
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.