Develop and maintain automated test frameworks for ETL and data pipelines using Python, PyTest, SQL, and Pandas. Perform end-to-end ETL testing, validate data accuracy and integrity, automate regression suites, design transformation test cases, investigate discrepancies, and collaborate with data engineers to improve QA processes and testing efficiency.
Role: ETL / Data Automation Engineers Key Responsibilities: Develop and maintain automated test frameworks using Python and PyTest Perform end-to-end ETL testing across source, staging, and target systems Create and execute data validation scripts using SQL and Pandas Ensure data quality by validating accuracy, completeness, and consistency Design and execute test cases for data transformations and data pipelines Identify, analyze, and resolve data discrepancies and defects Collaborate with data engineers to understand ETL workflows and business logic Automate regression and validation test suites for data pipelines Contribute to improving QA processes, automation coverage, and overall testing efficiency Required Skills: Strong programming skills in Python Experience with PyTest or similar automation frameworks Advanced SQL skills for data validation and analysis Hands-on experience with Pandas for data manipulation Solid experience in ETL/data testing and data validation techniques Good understanding of data warehousing concepts and ETL processes Strong analytical and problem-solving skills High attention to detail with a focus on data accuracy and integrity Nice to Have: Experience with Playwright
Hexaware Technologies Pune, Mahārāshtra, IND Office
North Block, Plot No. 19, Rajiv Gandhi InfoTech Park, MIDC - SEZ, Phase 3, Hinjawadi, Pune, Maharastra, India, 411057
Similar Jobs
Information Technology • Consulting
Design and execute test plans for ETL/data workflows, perform functional/integration/regression testing, validate backend data using SQL/Snowflake, read stored procedures, identify defects, and develop/maintain automation scripts and test documentation.
Top Skills:
Automation FrameworksETLPythonSnowflakeSQLStored Procedures
Information Technology • Consulting
Develop and execute automation test scripts for API Testing using various tools, create reusable automation frameworks, and lead test management tasks.
Top Skills:
PostmanRestassuredSouapiSQL
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead the technical evolution and long-term architecture of Jira Data Management. Drive enterprise-scale data movement, governance, resiliency, reliability, performance, security, and observability initiatives. Own a 12–24 month platform roadmap, lead major architectural programs from strategy through delivery, conduct design and incident reviews, solve high-risk technical problems, and mentor senior and principal engineers across Jira Platform.
Top Skills:
AWSData Streaming PlatformsDistributed SystemsEvent-Driven ArchitectureGCPGoIaasJavaJavaScriptJira CloudPaasPythonSaaS
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
