ETL Test Engineer

Fa Ewjt Saasfaprod1; Pune District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Fa Ewjt Saasfaprod1 is seeking a QA/Test Lead in Pune to guide testing for data warehousing and BI reporting. You will design test strategies, write test cases and oversee ETL validation against PowerBI and other BI tools.

The role requires strong SQL skills, experience with Oracle/MS SQL/Redshift, and hands-on automation with Java or Python. You will coordinate a testing team and report progress to clients and PMs.

Qualifications

• Experience in testing for Reporting, especially PowerBI.
• Ability to estimate time, resources and budget for testing activities.
• Experience organizing testing kick-off meetings and defining test strategy.
• Hands-on experience with data warehousing from modelling to reporting.
• Strong SQL querying across Oracle, MS SQL, PostgreSQL, Redshift or similar.

Responsibilities

• Define and implement test strategy for ETL and reporting.
• Develop and maintain test plans, cases and scripts.
• Coordinate testing activities and assign tasks to team members.
• Ensure KPI coverage and data quality against databricks/database.
• Prepare status reports and communicate with client.
• Review test documents and ensure timely delivery of milestones.

Skills

Excel

PowerBI

SQL

Python

Agile

Education

Bachelor's degree in Computer Science / Information Technology / Data Science

Tools

Azure DevOps

JIRA

Oracle

MS SQL

PostgreSQL

Redshift

Databricks

AWS (S3, Lambda, Athena)

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

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.

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