ETL Test Engineer

Ex; Pune District; On-site; INR 2,000,000 - 2,800,000; Full time

Job summary

Ex is seeking a Quality & Testing-Test Engineering lead in Pune with 9–12 years of experience in data warehousing and BI testing. You will drive test strategy, plan, and execution across ETL and reporting, ensuring KPI integrity in Power BI and related tools.

The role requires strong SQL, ETL testing, experience with BI dashboards, and collaboration with Agile teams including Azure DevOps/JIRA. This is a hands-on leadership position focused on end-to-end data quality.

Qualifications

• Graduate in Computer Science, Data Science, Information Technology, or a related field.
• Proficiency with Power BI or Tableau and Excel required.
• Strong SQL and data warehousing/testing experience; hands-on with ETL/Reporting.

Responsibilities

• Analyze requirements to estimate testing effort and resources.
• Define the Test Strategy and plan; lead testing activities.
• Organize testing kick-off and ensure KPI testing and data accuracy.
• Test End-to-End data warehousing, from modeling to reporting.
• Develop test cases, scripts, and dashboards; verify Power BI reporting.
• Coordinate with project stakeholders and manage risks and issues.

Skills

PowerBI

Tableau

Excel

SQL

Python

ETL Testing

Data Warehousing

UAT

Agile

Documentation

Education

B.E./B.Tech in Computer Science or related field

Tools

Azure DevOps

JIRA

Oracle

MS SQL

Redshift

Job description

• Job Role Quality & Testing-Test Engineering
• Experience (In Years) 9-12
• Job Location Pune

Job Description

Basic understanding of:

• Excel and visualization tool & working experience in PowerBI or Tableau or Similar.
• Batch and Real time data processing
• Agile Process (Scrum cadences, Roles, deliverables) & working experience in either Azure DevOps, JIRA or Similar

Responsibilities

Strong In/should have:

• Understanding the testing effort by analyzing the requirements of project.
• Estimating and obtaining management support for the time, resources and budget required to perform the testing.
• Organizing the testing kick-off meeting
• Defining the Test Strategy
• Building a testing team of professionals with appropriate skills, attitudes and motivation.
• Identifying Training requirements and forward it to the Project Manager (Technical and Soft skills).
• Developed the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.
• Should have done testing for Reporting, specially PBI
• Making sure all KPIs are testing with requirements and vs. databricks/database
• Arranging the Hardware and software requirement for the Test Setup.
• Assigning task to all Testing Team members and ensure that all of them have sufficient work in the project.
• End to End data warehousing systems from Data modelling to Reporting
• Hands-on experience with Database and reporting testing
• Hands-on experience on at least one of the Scripting/Programming languages like Unit or Python
• Writing complex SQL queries & working experience in Oracle, MS SQL, PostgreSQL, Redshift or Similar
• Understanding and writing functional specifications/technical specifications/Business rules/Data rules.
• Responsible for turning gathered requirements into test cases and scripts in both ETL & Reporting areas.
• Author test strategy, test plans, test cases, and/or test scripts required to validate requirements.
• Understanding and working experience in AWS Services (S3, Lambda, Athena, EMR etc)
• Ensuring content and structure of all Testing documents / artifacts is documented and maintained.
• Documenting, implementing, monitoring, and enforce all processes for testing as per standards defined by the organization.
• Reviewing the Test Cases documents.
• Keeping track of the new requirements / change in requirements of the Project.
• Escalating the issues about project requirements (Software, Hardware, Resources) to Project Manager / Sr. Test Manager.
• Organizing the status meetings and send the Status Report (Daily, Weekly etc.) to the Client
• Attend the regular client call and discuss the weekly status with the client.
• Strong Communication with the Client. • Act as the single point of contact between Development and Testers.
• Tracking and preparing the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
• Reviewed various reports prepared by Test engineers.
• Ensuring the timely delivery of different testing milestones.
• Preparing / updating the metrics dashboard at the end of a phase or at the completion of project.

Qualifications

Graduate in Computer Science, Data Science, Information Technology, or a related field.