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:
Required Skills & Experience:
Preferred Qualifications:
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 Senior API Developer will build and maintain APIs and Kafka integrations, improve performance, assist in production setups, and provide on-call support.
Top Skills:
AWSDockerJavaKafkaMicroservicesRestSpring Boot
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Associate Cloud Engineer will implement AWS solutions, automate management tasks, and work with DevOps and cloud technologies. Strong communication skills are essential.
Top Skills:
AnsibleArtifactoryAWSAzureBashGitIaasJenkinsLinuxPaasPowershellPythonTerraformWindows
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Data Engineer will design and implement data pipelines and ETL solutions, optimize performance, and lead small teams while ensuring high-quality data processing.
Top Skills:
AlationApache AirflowSparkAWSIdmcIicsInformaticaKafkaLookerMicrostrategyPythonSQLTableau
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.