Healthcare Data Integration / ETL Developer

About the role

Healthcare Data Integration / ETL Developer role located in Albany, NY.

Responsibilities

• Write SQL and PL/SQL (stored procedures/functions) with Oracle 12c or higher (including 19c) to Informatica mappings.
• Develop Rhapsody routes (Rhapsody 7) to acquire and manage millions of records of data, including XML and HL7 message formats.
• Use Informatica 8.x or higher (including 10.2) in a data warehouse environment, applying warehousing concepts and developing complex mappings.
• Apply Informatica Data Quality 8.x or higher (including 10.2) processes for data profiling, cleansing, standardization, match and merge.
• Specify and conduct system testing (unit, integration, regression, load, performance) and user acceptance testing.
• Work with health data adhering to HIPAA, HL7 or similar standards.
• Develop project timelines and gather/document business requirements.
• Program public sector government IT projects.

Qualifications

• 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 required.