Testing-ETL-Senior

Ernst & Young Advisory Services Sdn Bhd; Kolkata District; On-site; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Support & coaching

Skill development opportunities

Flexible work practices

Job summary

EY is seeking a Data Analytics Test Lead to oversee BI and data warehousing testing across on-premise and cloud platforms.

The role requires strong expertise in ETL testing, data validation and experience with Cognos, PowerBI, Tableau or Qlik. You will coordinate with cross-functional teams and mentor junior testers while ensuring high-quality deliverables.

Qualifications

• BE/BTech/MCA/M.Sc degree required with relevant analytics focus.
• 5–8 years in Testing Data warehousing / BI solutions with 3+ years in BI/DWH.
• Strong SQL on Oracle/SQL Server/Teradata/Snowflake/Postgres/Redshift.
• Experience with Cognos/PowerBI/Tableau/Qlik and ETL tools listed.

Responsibilities

• Develop Test Strategy for BI & DWH projects and align with plan.
• Design tests, prepare automation scripts where applicable.
• Coordinate with ETL developers, data engineers, analysts, PMs.
• Enforce data quality standards, profiling and cleansing.
• Lead testing efforts across on-premise and cloud platforms.
• Report progress, defects, and sign off with Test Manager.
• Provide analytics testing trainings and support in projects.

Skills

Test Strategy

Test Case design

Automation opportunities

Data quality standards

BI & DWH testing

Big data testing

Python data processing

Stakeholder coordination

Education

BE/BTech/MCA/M.Sc

Tools

Cognos

PowerBI

Tableau

Qlik

Informatica

SSIS

SAP Data Services

AWS Glue

Azure Data Factory

Oracle

SQL Server

Teradata

Snowflake

Databricks

Azure Synapse

Job description

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY- Consulting-Data Analytics Testing-Senior

The opportunity

As a Data Analytics Test Lead, you will be responsible for testing Business Intelligence & Data warehousing Solutions both in on premise and cloud platform and should ensure Quality of deliverables. You will work closely with Test Manager for the Projects under Test. Testing proficiency in ETL, data-warehousing, and Business Intelligence area are required for this position.

Added advantage to have experience in testing Big Data/unstructured data using Hadoop/Spark framework, cloud platform knowledge either in AWS/Azure, knowledge in predictive analytics, Machine Learning and Artificial intelligence.

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.
• 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 SQL’s 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

Ideally, you’ll also have

• Experience in Performance & Load Testing for backend systems is preferred. Exposure to Performance Tuning (Tuning concepts - indexes, segments, partitions, query tuning) of database systems would be an added advantage.
• Experience/ exposure to Test Automation and scripting experience in perl & shell is desirable
• Experience with Test Management and Defect Management tools preferably HP ALM
• Able to contribute as an individual contributor and when required Lead a small Team
• Able to create Test Strategy & Test Plan for Testing BI & DWH applications/ solutions that are moderate to complex / high risk Systems
• Design Test Cases, Test Data and perform Test Execution & Reporting. Should be able to perform Test Management for small Projects as and when required
• Participate in Defect Triaging and track the defects for resolution/ conclusion
• Good understanding of SDLC, test process in particular
• Good analytical & problem solving or troubleshooting skills
• Good understanding of Project Life Cycle and Test Life Cycle. Exposure to CMMi and Process improvement Frameworks is a plus. Should have excellent communication skills & should be able to articulate concisely & clearly
• Should be ready to do an individual contributor as well as Team Leader role

What working at EY offers

At EY, we’re dedicated to helping our clients, from start‑ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.