The Analyst QA will develop test strategies for ETL processes, create test cases, validate data accuracy, and automate tests. Collaboration with business and development teams is required.
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
Aws Redshift
Datastage
Google Bigquery
Informatica
Oracle
Postgres
Power BI
Python
Selenium
Snowflake
SQL
SQL Server
Ssis
Tableau
Talend
Vertica
Similar Jobs at MassMutual India
Big Data • Fintech • Information Technology • Insurance • Financial Services
Responsible for managing Quality Assurance and Quality Control services for Operations teams, ensuring adherence to quality standards and identifying process improvements. Collaborates with management to implement best practices and achieve optimization goals.
Top Skills:
AutomationBusiness AnalyticsLean Six SigmaMS Office
Big Data • Fintech • Information Technology • Insurance • Financial Services
As an Associate Data Engineer, you'll work with data warehousing, SQL, and Python to support data workflows, utilizing Airflow for orchestration.
Top Skills:
AirflowDwhPythonSQL
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Data Analyst - Lead at MassMutual India will review data delivery requirements, develop estimates and delivery schedules, design sourcing and data delivery, and contribute to project deliverables. The role focuses on data analysis, improving data management across various business areas, and collaborating with reporting teams.
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.
