Informatica TDM Architect

About the role

Job ID: J53041
Location: Dallas, TX
Duration: 12 Months + Extension
Hourly Rate: Depending on Experience (DOE)
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD
Client: To Be Discussed Later
Employment Type: W-2, 1099, C2C

Job Overview

• 5+ years working with Healthcare payer
• US Healthcare Domain Experience is Mandatory
• Test Data Manufacturing through Application UI/Front end is mandatory
• Understanding application landscape and identifying the E2E Data flow
• Healthcare Data and Business knowledge with understanding of the terminology, concepts, and value chain
• Strong understanding of various Test data manufacturing techniques
• Strong hands on experience in working with Healthcare Payer industry
• Added advantage of having IBM Optim experience
• Experience in TDM solutioning (Data de-identification, sub-setting)
• Solid understanding of information warehousing and large-scale data management issues and concepts
• Solid understanding of physical database design
• Ability to work towards meeting stringent milestones
• Ability to work in a team environment with on-site and offshore resources
• Prominent project planning, execution abilities with strong communication and interpersonal skills
• Strong analytical skills
• Ability to prepare, present oral and written reports, presentations, and recommendations and to perform necessary actions
• Ability to accept high level assignments and work with limited supervision and guidance
• Excellent work history and attendance record
• Certified in Database Administration/ Programming/ Informatica TDM

Responsibilities

• Responsible for understanding the existing database or data source models and owning the solutions for production data de-identification and sub-setting into the lower environments.
• Proficient in analysing existing application landscape, identify data flow diagram across applications/system and extract data dictionaries from source systems.
• Capable of extracting relationships between different databases and corresponding tables.
• Read and understand the data dictionaries of source systems.
• Healthcare business domain knowledge and experience related to the account/Groups, Members, Providers and Claims manufacturing is mandatory
• Test Data Manufacturing experience using the application front end, UI, files, etc.
• Experience in understanding the E2E Data flow, its dependencies and ensure the data integrity across various applications, products and product lines
• Experience in handling different types of DB and expertise in DQL, DDL, DML and Support DBA activities for data copying/ backup
• Configure the subset/filters to be used for IBM Optim or Informatica TDM for data subset for various source data systems.
• Data Validation of subsets created
• Capture subset metrics for reporting.
• Design a framework that will enable data governance model in non production environments to arrest the flow of production data into non production environments.
• Direct teams to implement the framework designed.

Qualifications

• Ability to work towards meeting stringent milestones
• Ability to work in a team environment with on-site and offshore resources
• Prominent project planning, execution abilities with strong communication and interpersonal skills
• Strong analytical skills
• Ability to prepare, present oral and written reports, presentations, and recommendations and to perform necessary actions
• Ability to accept high level assignments and work with limited supervision and guidance
• Excellent work history and attendance record

Skills

• Informatica TDM

Benefits

• Equal Opportunity Employer