Role: Test Data Engineer (TDM)
Location: Canada (Remote)
Hire Type: Fulltime
Job Description
Position Summary:
Test Data Management (TDM) plays a key role in sourcing the right data with every changing needs to make sure software testing is done effectively. Test data administration is the way of creating non-production data that reliably mimic an organization's actual data so that systems can be rigorously tested. It is a measure of quality and quantity of data that is available in non-prod environments. This role will be accountable for understanding test data requirements, performing data discovery, protecting sensitive data using masking techniques, creating test data warehouse and enabling test data availability to users in Client
Essential Job Functions:
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 working 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 analyse 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 the 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