Test Data Management Engineer

• Define, implement, and adopt TDM strategy, technical solution, processes & methodology, delivery model, standards & governance.
• Establish test data supply chain (from prod to non-prod) applying masking, sub-setting to build gold copy test data set.
• Good understanding of the application architecture/domains and data flows across systems.
• Implement test data management function with NoSQL & relational data sources.
• Proficient in TDM tools (Informatica IDMC, CA, Delphix or others) for masking, sub setting, synthetic data generation & gold copy.
• Support, operate and maintain TDM’s environment, platform, and services.
• Integrate TDM solution with Test Automation framework, automate test data refresh and creation process, integrate with CI / CD pipelines.
• Service test data requests, perform data identification / analysis across data sources for required scenarios.
• Analyze business requirements, work closely with project team members, technical leads, and business partners to arrive at an optimal solution design.
• Conduct feasibility analysis, create high level design document, and review it with key identified stakeholders.
• Perform proof of concept (POCs) on agreed approach and provide presentations to key stakeholders.
• Excellent in writing complex SQL queries.
• Capable of handling multiple programs simultaneously and work under offshore and Onsite model.
• Provide support to identify test data required to test specific business scenarios.
• Coordinate with application DBAs to copy data from one environment to another while protecting customer sensitive information. Document data quality issue findings and recommendations.
• Demonstrated ability to provide high volumes of test data with referential integrity required to support Test execution.
• Perform data analysis when needed to analyze issues in Pre-production and/or Production environments in Cloud and/or on-premises infrastructure.
• Prepare test data reports/metrics for stakeholders.
• Experience in defect management process, and defect triage calls.
• Mentor and groom team members on product/application features/functionality and domain.
• Knowledge of any of database systems like SQL Server, Oracle or db2 etc
• Working knowledge of test management tools like HP ALM/ Quality Center/ Jira/Qmetry
• Excellent verbal and written communication skills.

Minimum Positions Qualifications/Education Requirements:

• 6+ years of software product development, testing and delivery experience.
• 5+ years of TDM/SQL experience.
• 3+ years of Informatica Power Center, IDQ, IICS/IDMC experience.
• 2+ years of experience in some of the Azure Cloud tools: ADF, Pyspark, databricks notebooks
• 1+ Experience with Python and libraries like Panads, Numpy & Matplotlib.
• Familiar with Latest Cloud Technologies.

Mandate Key Skills:

• Expertise in TDM Strategy and Implementation: including defining and driving TDM strategy, governance, and delivery model as a core function.
• Strong proficiency in SQL for data identification, extraction, transformation, and analysis: SQL, NonSQL, Relational Database.
• Experience with TDM Tools & Automation: Hands-on experience with TDM tools like Informatica IDMC, CA, Delphix
• Experience with Azure Cloud tools: Azure Data Factory, PySpark, Databricks Notebooks.
• Experience with test management tools like: HP ALM, Jira, QMetry