Cookies & analytics consent
We serve candidates globally, so we only activate Google Tag Manager and other analytics after you opt in. This keeps us aligned with GDPR/UK DPA, ePrivacy, LGPD, and similar rules. Essential features still run without analytics cookies.
Read how we use data in our Privacy Policy and Terms of Service.
🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
UST • pune, Maharashtra, India
Role & seniority: SDET (Mid-Level to Senior) focused on Data Integration & Transformation; full-time in Quality Engineering / Data Engineering.
Location & work type: Pune, India; Full-time; work hours up to 9:30 PM IST.
Stack / tools: Java, automation testing, ETL testing, API testing (without UI); data formats (JSON, XML, Avro, Parquet); SQL for test validation; Python or Java scripting; test frameworks (JUnit, TestNG, PyTest); CI/CD (Jenkins, GitLab CI, CircleCI); data tools (Apache NiFi, Talend, Informatica); familiarity with big data (Kafka, Spark, Hadoop); cloud data services (AWS/GCP) preferred; Great Expectations (mentioned).
Design, develop, and maintain automated test frameworks for data integration and transformation workflows.
Create and execute tests for ETL pipelines, data pipelines, and APIs; validate data quality, schema, completeness, and correctness.
Integrate test automation into CI/CD; document defects; collaborate on root cause analysis; support requirement analysis and risk assessment.
Strong test automation in data integration/transformation environments.
ETL/ELT knowledge, data validation, transformation logic; SQL for validation; scripting in Python/Java.
Experience with testing frameworks (JUnit, TestNG, PyTest); API testing; JSON/XML data handling.
Role Description
Job Title: SDET – Data Integration & Transformation
Location: Pune, India
Job Type: Full-time Experience Level: [Mid-Level / Senior]
Department: Quality Engineering / Data Engineering
Work Time: upto 9.30 PM IST
Mandatory: Java, Automation Testing, ETL Testing, API Microservices Testing without UI, Experience with testing data format transformation JSON, XML -> XML Job
Summary: We are seeking a highly skilled and detail-oriented SDET (Software Development Engineer in Test) with expertise in test automation for data integration and transformation processes. The ideal candidate will work closely with data engineers and developers to build robust, automated testing frameworks ensuring data quality, consistency, and integrity across complex ETL and integration pipelines. ________________________________________ Key Responsibilities:Design, develop, and maintain automated test frameworks for validating data integration and transformation workflows.Collaborate with data engineers to understand data flow, business rules, and transformation logic.Create and execute test cases for ETL processes, data pipelines, and APIs.Validate data quality, schema, completeness, and correctness across multiple data sources and targets.Automate regression, integration, and end-to-end testing for data-driven applications.Implement tests for data accuracy, consistency, duplication, and loss.Work closely with DevOps teams to integrate test automation into CI/CD pipelines.Participate in requirement analysis, risk assessment, and test planning activities.Document defects clearly and collaborate on root cause analysis and resolutions.
________________________________________ Required Skills & Experience: Strong experience with test automation in data integration and transformation environments.Solid understanding of ETL/ELT pipelines, data validation, and transformation logic.Proficiency in writing SQL queries for test validation and data profiling.Hands-on experience with Python, Java, or similar scripting languages for test automation.Familiarity with data integration tools (e.g., Apache NiFi, Talend, Informatica, etc.) is a plus.Understanding of data formats like JSON, XML, Avro, and Parquet.Experience with test frameworks such as PyTest, JUnit, TestNG, or similar.Knowledge of CI/CD tools like Jenkins, GitLab CI, or CircleCI.Familiarity with big data platforms and distributed systems (e.g., Kafka, Spark, Hadoop) is a plus. ________________________________________ Preferred Qualifications:Exposure to cloud data ecosystems (e.g., AWS Glue, Redshift, S3, EMR, GCP BigQuery).Experience with data cataloging and data lineage tools.Understanding of data governance and security compliance.Strong communication and collaboration skills with both technical and non-technical stakeholders. * Test Automation using Great Expectation Tool
Skills
etl testing,java,api testing,database testing, Show more Show less