Informatica Data Engineer

Mindlance; Village of Menands (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Mindlance in New York is seeking a senior data integration specialist to design and implement ETL mappings and data pipelines using Informatica.

The ideal candidate has 7+ years of experience in EMR/healthcare data, Rhapsody routing, HL7/XML formats, and a solid grasp of data quality and warehousing concepts. This role requires collaboration with cross-functional teams and adherence to HIPAA standards.

Job description

• 84 Months Experience writing SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
• 84 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats
• 84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings
• 84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge
• 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
• 84 Months Experience working with Health Data with HIPAA, HL7 or similar standards
• 60 months experience developing project timelines, gathering and documenting business requirements.
• 48 Months experience in programming public sector government IT projects.
• Project Management Professional Certification

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”