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
As a Data Engineer, you'll design and build ELT jobs, manage data quality, document system flows, and implement data pipelines for business needs.
Top Skills:
AirflowETLJavaPysparkPythonRedshiftSQLVertica
Big Data • Fintech • Information Technology • Insurance • Financial Services
The Senior Associate will design and develop Power BI reports, implement security, collaborate with stakeholders, guide BI developers, optimize SQL queries, and ensure adherence to Agile practices.
Top Skills:
AgileDaxJIRAPower BISQL
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
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
