ETL Testing Engineer

21 hours ago

Chennai, Tamil Nadu, India BRISKWIN IT SOLUTIONS PRIVATE LIMITED Full time ₹ 4,00,000 - ₹ 8,00,000 per year

Description :

About the Role :

We are seeking a highly skilled and self-motivated ETL Testing Engineer with specialization in Test Data Management (TDM) and hands-on experience using GenRocket.

In this role, you will be responsible for building data provisioning frameworks and utilities, performing advanced test data management tasks, and developing automated solutions for synthetic data generation, masking, and validation across enterprise-wide data ecosystems.

You will collaborate with development, QA, and DevOps teams to ensure data quality and availability across environments, enabling faster and more reliable testing cycles.

Key Responsibilities :

- Design and implement scalable TDM frameworks that support test data provisioning, masking, subsetting, and archiving.

- Develop and maintain automated utilities for self-service data provisioning using Java, Groovy, or Python.

- Create Gold Copy databases and reusable data stores to optimize test data usage and refresh cycles.

- Support data discovery, profiling, and classification activities to identify sensitive data and data dependencies.

- Architect and execute synthetic test data generation strategies using GenRocket or equivalent tools.

- Perform end-to-end ETL testing, including source-to-target data validation, transformation logic testing, and reconciliation.

- Write and execute complex SQL queries to validate data across multiple RDBMS systems and cloud platforms (e.g., AWS, Azure, GCP).

- Test and validate data from APIs and ElasticSearch endpoints where applicable.

- Create and execute test cases and scripts based on data mapping documents and business rules.

- Implement data masking strategies to protect sensitive information while maintaining referential integrity.

- Ensure compliance with data privacy standards (e.g., GDPR, HIPAA) in test environments.

- Leverage GenRocket and/or Informatica TDM, or similar tools, for secure and policy-compliant data masking.

- Define test data governance models, standards, and guidelines to ensure efficient data usage.

- Establish reusable data assets, and ensure the traceability of test data from creation to purge.

- Automate data refresh, archival, and retention procedures to manage the test data lifecycle efficiently.

- Handle test data requests and priorities in coordination with project and QA teams.

Required Technical Skills :

- Strong experience with ETL validation, data reconciliation, data transformation, and data migration testing.

- Deep experience with GenRocket, Informatica TDM, or similar tools for synthetic data generation and masking.

- Proficiency in Core Java, Groovy, or Python.

- Advanced SQL skills and experience working with RDBMS such as Oracle, SQL Server, PostgreSQL, MySQL.

- Exposure to cloud data services (AWS RDS, Azure SQL, etc.) and validation using API services (e.g., REST, ElasticSearch).

- Strong understanding of data discovery, profiling, masking, subsetting, and archival techniques.

  • ETL Testing

    1 week ago

    Chennai, Tamil Nadu, India Cognizant Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Key skills: ETL TestingExperience: 6 to 9 yearsLocation: BhubaneswarJob Summary: We are seeking a detail-oriented and experienced Testing Engineer to join our team. The ETL Testing Engineer will be responsible for designing, executing, and automating test cases to ensure the quality and integrity of data extracted, transformed, and loaded into data...

  • ETL Test Engineer

    1 day ago

    Chennai, Tamil Nadu, India FIS Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Position TypeFull timeType Of HireExperienced (relevant combo of work and education)Education DesiredBachelor's DegreeTravel Percentage0%Job DescriptionETL Testing with SQLAre you curious, motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most challenging and relevant projects in financial services and technology. Our...

  • ETL Testing professional

    7 days ago

    Chennai, Tamil Nadu, India Krazy Mantra HR Solutions Pvt. Ltd Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are looking for a skilled ETL Testing professional with 8 to 11 years of experience to join our team in Chennai. The ideal candidate will have expertise in ETL testing, SQL queries, and Informatica Power Center.Roles and ResponsibilityDesign and develop comprehensive test plans for ETL processes to ensure data integrity and accuracy.Develop and execute...

  • Etl Test Lead

    3 days ago

    Chennai, Tamil Nadu, India Agilisium Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Analyze business and data requirements within the Life Sciences domain, including clinical, regulatory, and commercial data use cases.Design and execute comprehensive ETL test plans and test cases for data pipelines involving AWS S3, Redshift, Snowflake, and Databricks.Validate complex data transformations, aggregations, and data quality rules across data...

  • Urgent opening- ETL testing

    1 day ago

    Chennai, Tamil Nadu, India SBS Consultants Full time ₹ 78,000 - ₹ 79,500 per year

    Urgent opening- ETL testing - Chennai Salary - upto 6.5 lpa max NP - 20 days max Exp - 2 plus in ETL testing Email -

  • Senior ETL QA Engineer

    3 days ago

    Chennai, Tamil Nadu, India Virtusa Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    P2-C3-TSTSQuality Engineers Design and execute test plans and test cases for ETL processes and data flows on CloudValidate data extraction, transformation, and loading (ETL) processes from source to target systems.Write and execute complex SQL queries to perform data validation, reconciliation, and analysis.Identify, document, and track defects and data...

  • ETL Testing Pyspark

    1 day ago

    Chennai, Tamil Nadu, India Virtusa Full time

    At least 6 years of IT experience with minimum 5 years of experience in below skillsTech SkillsProficiency in ETL Testing and developing automation framework testcases in atleast one scripting languageExperience in Pypark is MandatoryStrong SQL skills with experience in handling big data using ETL tools eg InformaticaTesting experience in cloud environment...

  • ETL Tester

    3 days ago

    Chennai, Tamil Nadu, India The Value Maximizer Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Key Responsibilities:Design and execute ETL test plans, test cases, and test scripts to validate data transformations and data qualityDesign, develop, and execute functional test casesConduct functional testing to ensure that ETL processes and data pipelines meet business requirementsCollaborate with data engineers, developers, and business analysts to...

  • ETL Automation Test Lead

    3 days ago

    Chennai, Tamil Nadu, India CymbalTech Consulting Full time ₹ 1,00,000 - ₹ 12,00,000 per year

    ETL Automation Test LeadLocation: Chennai/Hyderabad/Bangalore/ Pune/ Noida/ Gurugram7+ yrs expFull-timeStrong in ETL Testing, API Automation (SOAP/REST/GraphQL), Java, Groovy, SQL | Lead QA team, build automation frameworks, ensure data integrity & API qualitySend your resume to Job Type: Full-timePay: ₹1,000, ₹1,200,000.00 per yearWork Location: In...

  • Testing Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Global power tech testing and contracting Full time ₹ 1,44,000 - ₹ 1,80,000 per year

    Job Title: Test Engineer (Fresher)Company: Power Tech Group of CompaniesLocation: Padi, ChennaiSalary: ₹12,000 – ₹15,000 per month (Negotiable)Test Engineer (Power Plant – Valve Testing)Eligibility:Education: Diploma / Degree in Electrical or Mechanical (Freshers can apply)Good communication skills (Hindi is an added advantage)Willing to travel...