ETL Test Engineer

EXL Talent Acquisition Team; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

EXL Talent Acquisition Team in Pune invites an experienced Quality & Testing - Test Engineering professional to lead end-to-end testing for data warehousing and reporting projects. You will define test strategies, build testing teams, and coordinate with clients to ensure on-time, high-quality deliveries.

With 9–12 years in QA/testing, you will work with ETL, SQL, and BI tools (PowerBI/Tableau), drive test plans, and ensure KPIs are validated against Databricks/ databases.

Qualifications

• Graduate with CS/IT/Data Science or related field.
• 9–12 years of QA/testing experience.
• Experience with ETL and reporting testing, data warehousing, SQL and databases.

Responsibilities

• Understand testing requirements and estimate resources and budget.
• Define the Test Strategy and build a testing team with required skills.
• Organize testing kick-off meetings and manage testing deliverables.
• Turn requirements into test cases and scripts for ETL and reporting.
• Write and maintain test plans, test cases, and test scripts.
• Ensure testing coverage for KPIs, Databricks, and databases.
• Coordinate with client and project manager; provide status reports.
• Hands-on testing for data warehousing, reporting, and BI validation.
• Review test artifacts and ensure timely delivery of milestones.
• Communicate effectively with stakeholders and act as a single point of contact between dev and QA.

Skills

Testing leadership

Requirement analysis

Test planning

SQL

Education

Bachelor's degree in CS/IT/Data Science

Tools

Azure DevOps

JIRA

PowerBI

Tableau

Databricks

Oracle

MS SQL

PostgreSQL

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.