Key Responsibilities:
- Understand business and data requirements to develop effective test strategies and test plans for ETL processes.
- Design, develop, and execute ETL test cases, SQL queries, and test scripts for data validation.
- Perform data completeness, transformation, and reconciliation testing to ensure data accuracy across various systems.
- Validate data mapping, schema changes, and data load processes in the data warehouse.
- Identify, document, and track defects using JIRA / HP ALM / any other defect tracking tool.
- Work closely with the development and business teams to resolve data discrepancies and issues.
- Perform performance testing to analyze ETL job execution time and improve efficiency.
- Automate ETL test scripts using tools like Python, Selenium, or any other automation framework.
Required Skills:
- Strong SQL skills - Ability to write and optimize complex queries for data validation.
- Hands-on experience with ETL tools such as Informatica, Talend, DataStage, SSIS, or others.
- Knowledge of data warehouse concepts, star/snowflake schemas, and relational databases (Vertica, Oracle, SQL Server, PostgreSQL, etc.).
- Experience in ETL testing methodologies - Data completeness, correctness, transformation, and reconciliation testing.
- Hands-on experience with BI tools like Power BI, Tableau for report validation.
- Familiarity with defect tracking tools (JIRA, HP ALM, Bugzilla, etc.).
- Basic understanding of Big Data and Cloud platforms (AWS Redshift, Snowflake, Google BigQuery, etc.) is a plus.
- Knowledge of scripting languages (Python, Selenium with Java) for test automation is desirable.
- Experience in working within Agile/Scrum methodologies.
Preferred Qualifications:
- Bachelor's or master's degree in computer science, Information Technology, or a related field.
- ETL Testing certification (if any) is a plus.
- Experience in automation testing for ETL workflows.
Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and in a team-oriented environment.
Top Skills
What the Team is Saying
What We Do
With our world class Global Capability Centre (GCC) in the heart of Hyderabad, we at MassMutual are extending a nearly 170-year legacy of securing futures and protecting loved ones to Telangana, India in 2020. The Hyderabad GCC has been established to explore the global talent pool with an in-house team of experts in full-stack Development & Support, DevOps, Quality Assurance, Security & Cloud Engineering, Data Science and several other areas such as insurance, business, security, and operations.
Living Mutual has always been at the core of MassMutual’s purpose. Since 1851, MassMutual’s mutual way of life has been reflected in its various initiatives, be it Social Responsibility, Corporate Governance, or Diversity & Inclusion.
With the opening of our Hyderabad facility, you’ll not only get to work in our innovative, state-of-the-art Global Capability Centre, you’ll also be supported by colleagues in our global MassMutual community.
Spread across 73000+ square feet facility on the 7th floor of BSR IT SEZ, the Global Capability Center in Hyderabad can house more than 600 employees. Located at the heart of Financial District, the facility boasts of work class infrastructure and amenities, enabled by state-of-the-art technology and security systems. In-house gymnasium / aerobics center, yoga room, indoor games room, mothers’ / wellness room, 200+ seater cafeteria, high-rise & lounge seating are some of the amenities available for the employees. The SEZ facility will also provide common creche and eat-out restaurants in the building premises, once operational.
Join us now to collaborate with teams across the world on projects and initiatives that will contribute to the growth of MassMutual as a global financial services leader.
Why Work With Us
MassMutual is leading the financial services industry in digital enablement, and the new MassMutual
India Global Capability Center is a result of this effort. We are here to empower careers and help
people secure their futures through innovation and technology.
Gallery
MassMutual India Offices
OnSite Workspace
