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 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.
