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.