ETL Test Engineer

Posted 22 Days Ago
Be an Early Applicant
Pune, Mahārāshtra, IND
Hybrid
Entry level
Information Technology • Database • Consulting
The Role
Plans, coordinates, and executes end-to-end ETL and reporting testing. Develops test strategies, plans, cases, and automation scripts; validates KPIs against databases and Databricks; tests data warehouses from modeling through reporting; writes complex SQL; manages testing resources, documentation, defects, metrics, and milestones; and communicates status, risks, and results to project managers, developers, testers, and clients.
Summary Generated by Built In

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 
  • Automation testing using Java, Python etc. 
  • 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. 

Skills Required

  • Graduate degree in Computer Science, Data Science, Information Technology, or a related field
  • Basic understanding of Excel and visualization tools, with experience using Power BI, Tableau, or similar
  • Understanding of batch and real-time data processing
  • Understanding of Agile processes, Scrum cadences, roles, and deliverables
  • Experience with Azure DevOps, JIRA, or similar tools
  • Experience testing reporting applications, especially Power BI
  • Experience validating KPIs against requirements and Databricks or database sources
  • End-to-end data warehousing experience from data modeling through reporting
  • Hands-on database and reporting testing experience
  • Hands-on experience with at least one scripting or programming language, such as Python
  • Ability to write complex SQL queries
  • Experience with Oracle, Microsoft SQL Server, PostgreSQL, Amazon Redshift, or similar databases
  • Automation testing experience using Java, Python, or similar languages
  • Understanding of functional specifications, technical specifications, business rules, and data rules
  • Experience creating test cases and scripts for ETL and reporting
  • Experience authoring test strategies, test plans, test cases, or test scripts
  • Understanding and working experience with AWS services such as S3, Lambda, Athena, and EMR
  • Strong client communication and stakeholder management skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
30,246 Employees
Year Founded: 1999

What We Do

Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.

Similar Jobs

Magna International Logo Magna International

Engineer, Lead Product

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Pune, Mahārāshtra, IND
171000 Employees

Optum Logo Optum

Data Scientist

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Pune, Mahārāshtra, IND
160000 Employees

Optum Logo Optum

Subject Matter Expert

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Pune, Mahārāshtra, IND
160000 Employees

Coursera + Udemy  Logo Coursera + Udemy

Architect

Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Remote or Hybrid
India
1500 Employees

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account