Job Description :
Job Title: Informatica Test Data Management (TDM)

Location: Baltimore, MD

Duration: 6+ Months

Must haves: TDM experience (development), Informatica

Responsibilities

· The Test Data Management (TDM) role will be responsible for planning, discovery, design, development, and maintenance of test data using appropriate test data management tools and techniques. This role will develop test data management strategies and plans to provide right sized, production like, reusable and secured test data per test data requirements, as well as discover, generate, profile, transform, enrich, cleanse, extract, subset, mask, load, validate, refresh, reset, archive, purge test data and resolve defects of test data using Informatica Information Lifecycle Management (ILM), Test Data Management (TDM), automation tools and SQL scripts.

· TDM Lead will manage both on and offshore test data management teams throughout all phases of the test data management, including planning, design, development, provisioning and maintenance of test data. They will implement the development of the test data management strategy and focus specifically on maximizing test data reuse, safety, initial state repeatability, profiling, catalog and versioning. In designing test data management strategy, they will have a thorough understanding of data governance which subsets data quality, information life cycle management (data modelling, data development and admin), metadata, master data management and data security. This role will implement the strategy via developing, coding and executing test data discovery, architecting, sub setting, masking, provisioning and maintenance solutions using automated test data architect, profiling, cleansing, validation, sub setting and privacy.

· Extensive knowledge of databases, data warehouses, systems integrations, and data flows is preferred for this role. Additionally, candidates should be well-versed in data architecture, data development, test data management tools configuration and development, with a proven history of providing effective test data solutions. Extensive knowledge of business processes and related data flows and system integrations is also preferred for this position.



Technical Qualifications:

· At least 8 years hands experience in Informatica ETL tools

· Sound knowledge understanding the relational databases bases - Oracle ,Teradata, DB2 and SQL server

· Capability to develop complex SQL queries and ETL tool transformations logic

· Good understanding in writing regular expressions and database metadata definitions

· Writing automation shell scripts in add-on advantage

· Experience writing Informatica workflows and guiding team members in project implementations

· Good understanding SDLC life cycle of Waterfall and Agile implementations

· Capable to prepare project estimations and release plans

· Good understanding HIPPA, PCI,PII and PHI compliance sensitive data

· Hands on experience using Informatica power centre and database client tools i.e. Toad and SQL developer

· Good understanding in relational database ,data warehouse architecture and Logical design and dataflow diagrams

· Solid experience in Informatica workflow performance tuning and trouble shooting

· Ability to prepare project Design artifacts and code review check lists

· Coordinate and manage onsite ,offshore teams on project deliverable
             

Similar Jobs you may be interested in ..