Informatica TDM Architect

Qualifications

• 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 toward meeting stringent milestones
• Ability to work in a team environment with on‑site and offshore resources
• Proven 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

• Responsible for understanding the existing database or data source models and owning the solutions for production data de‑identification and sub‑setting into lower environments
• Proficient in analysing existing application landscape, identifying data flow diagram across applications/systems, and extracting 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 ensuring data integrity across various applications, products, and product lines
• Experience in handling different types of DB and expertise in DQL, DDL, DML and supporting DBA activities for data copying/backup
• Configure the subset/filters to be used for IBM Optim or Informatica TDM for data subsets from various source data systems
• Data validation of subsets created
• Coordinate and work directly with customer stakeholders to identify the requirements and implement solutions for data de‑identification, sub‑setting, and refresh into lower environments
• Groom project team members on Informatica TDM best practices
• Help understand the existing customer environments and coordinate with infrastructure teams for any additional capacity/resizing, etc.
• Data profiling of the de‑identified data copies for quality assessment
• Capture subset metrics for reporting
• Design a framework that enables a 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

• Ability to work toward meeting stringent milestones
• Ability to work in a team environment with on‑site and offshore resources
• Proven 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

CLOUD ANALYTICS TECHNOLOGIES is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status, or any other protected status. CLOUD ANALYTICS TECHNOLOGIES will not make any posting or…