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 Chennai, Tamil Nadu, IND Office
MCN Nagar Ext, MCN Nagar Extension, Thoraipakkam, Chennai, Tamil Nadu, India, 600097
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 • Security • Software
Manage 1–2 engineering teams responsible for authorization and identity services. Lead secure delivery, architectural roadmaps, scalability initiatives, cloud-native migrations, operational reliability, and protocol evolution for LDAP and RADIUS systems. Provide technical direction, staffing and budget oversight, coaching, stakeholder alignment, release governance, and change management. The role requires deep IAM expertise, hands-on technical judgment, and participation in on-call rotations.
Top Skills:
Authentication ProtocolsCloud-Native ArchitectureCursorGithub CopilotIdentity And Access Management (Iam)LdapRadius
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

