Informatica TDM Architect

Cloud Analytics Technologies, LLC; Dallas (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

A prominent analytics firm in Dallas is seeking a qualified Database Administrator with extensive knowledge of the Healthcare payer industry. The candidate must have a minimum of 5 years of experience in data de-identification and management techniques. Responsibilities include understanding data flows, collaborating with stakeholders, and leading projects to ensure data integrity across various systems. Strong communication and analytical skills are required. This role offers opportunities to advance within a dynamic team.

Qualifications

• 5+ years of experience working with Healthcare payers.
• Strong understanding of various Test data manufacturing techniques.
• Proven project planning and execution abilities.

Responsibilities

• Responsible for understanding and owning solutions for production data de-identification.
• Analyze application landscape and data flow diagrams.
• Work with customer stakeholders to identify requirements.

Skills

Healthcare payer experience

Data de-identification

Data management

Analytical skills

Communication skills

Education

Certified in Database Administration/Programming/Informatica TDM

Tools

IBM Optim

Informatica TDM

Job description

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

Responsibilities

• 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

Managerial Skills

• 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 employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.

Equal Opportunity Employer

CLOUD ANALYTICS TECHNOLOGIES LLC 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 LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.