Senior Etl Tester

EY; Kolkata District; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

EY is seeking an experienced BI/DWH testing professional in Kolkata to lead ETL and reporting test efforts. You will craft test strategies, design cases, and drive automation initiatives using Python/PySpark while ensuring data quality across complex data pipelines.

Collaboration with ETL developers and data engineers will be essential to meet timelines. The role requires strong SQL skills, experience with cloud data platforms, and exposure to BI tools like Cognos, PowerBI, Tableau or Qlik.

Qualifications

• BE/BTech/MCA/MSc or equivalent.
• 5–8 years in Testing Data warehousing/BI solutions.
• 3+ years in BI & DWH testing and analytics applications.
• Strong SQL with complex data validation across Oracle/SQL Server/Teradata/Snowflake/Redshift.
• Exposure to ETL tools like Informatica, SSIS, SAP Data Services, AWS Glue, Azure Data Factory.
• Experience with cloud data services (AWS/Azure/GCP) and Databricks/Azure Synapse.

Responsibilities

• Develop test strategy for BI & DWH projects including ETL and reports testing.
• Design test cases and explore automation opportunities with Python/PySpark.
• Ensure test readiness: environment, data, licenses; manage test execution and defect reporting.
• Coordinate with ETL developers, data engineers, analysts, and project managers to align testing with timelines.
• Maintain data quality standards, profiling, and cleansing throughout pipelines.
• Lead cross-geo testing teams and present test metrics and progress to stakeholders.
• Perform big data testing on on-premises and cloud platforms; validate data integrity across pipelines.

Skills

ETL testing

Python

PySpark

SQL

Data quality

Testing strategy

Education

BE/BTech

MCA

MSc

Tools

Cognos

PowerBI

Tableau

Qlik

Snowflake

Job description

Must Have: ETL Testing, Python/Pyspark for automation and SQL (advance SQL)

Skills and attributes for success

• Develop Test Strategy for Testing BI & DWH Projects for various aspects like ETL testing & Reports testing (Front end and Backend Testing), Integration Testing and UAT as needed. Provide inputs for Test Planning aligned with Test Strategy.
• Perform Test Case design, identify opportunity for Test Automation. Develop Test Cases both Manual and Automation Scripts as required.
• Ensure Test readiness (Test Environment, Test Data, Tools Licenses etc)
• Coordinate testing efforts with cross-functional teams, including ETL developers, data engineers, business analysts, and project managers, to ensure testing aligns with project timelines and objectives
• Establish and enforce data quality standards, data profiling, and data cleansing procedures to maintain high-quality data.
• Delivery of Testing needs for BI & DWH Projects.
• Perform unstructured data / big data testing both in on-premise and cloud platform.
• Thorough understanding of Requirements and provide feedback on the requirements.
• Perform Test execution and report the progress. Report defects and liaise with development & other relevant team for defect resolution.
• Prepare Test Report and provide inputs to Test Manager/ Lead for Test Sign off/ Closure
• Provide support in Project meetings/ calls with Client for status reporting.
• Provide inputs on Test Metrics to Test Manager/ Lead. Support in Analysis of Metric trends and implementing improvement actions as necessary.
• Handling changes and conducting Regression Testing
• Generate Test Summary Reports
• Co-coordinating Test team members and Development team in order to resolve the issues
• Interacting with client-side people to solve issues and update status
• Able to lead team across geographies
• Actively take part in providing Analytics and Advanced Analytics Testing trainings in the company

To qualify for the role, you must have

• BE/BTech/MCA/M.Sc
• Overall 5-8 years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 3 years of experience in Testing BI & DWH technologies and Analytics applications.
• Strong in Data warehouse testing - ETL and BI and having exposure to the reporting tools such as Cognos/PowerBI/Tableau/Qlik etc
• Exposure to one or more ETL tools such as Informatica, SSIS, SAP Data services, AWS Glue, Azure Data factory
• Strong SQL skills with experience in writing complex data validation SQLs on databases like Oracle/ SQL Server/ Teradata / Snowflake/Postgres/Redshift
• Proficiency in data services of any leading cloud providers like AWS, Azure, GCP and thorough knowledge on data platforms like Databricks, Azure synapse
• Validate data integrity and consistency across various stages of ETL pipelines.
• Experience in master data management (MDM) is added advantage
• Working experience with python data processing is desirable.
• Work with cross-functional teams to ensure that ETL solutions meet business needs and quality standards.
• Experience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing is desirable