Responsibilities:
Using Informatica to develop ETL mappings and workflows including the use of maplets, reusable transformations and worklets.
Using Informatica Data Quality and Power Center.
Working with large and complex Oracle data warehouses, data marts and OLTP databases.
Following agency IT standards and procedures to develop and test ETL processes and migrate them from the Development environment thru the QA environment and into the Production environment.
Investigating and resolving data loading and/or data integrity issues.
Writing clear documentation.
Required Skills:
60 months of demonstrated experience using Informatica 8.6 or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings.
60 months of demonstrated experience working with Oracle 10g or higher and PL/SQL.
60 months of demonstrated experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.
24 months of demonstrated experience with ETL for Master Data Management and/or Healthcare information Exchanges.
24 months of demonstrated experience working with Patient Medical Records in State, Federal or Private Industry.
24 months of demonstrated experience with Healthcare Interchange standards including HL7, CCD or CCR.