Estimated Length: 24 months Full-Time 8 hour days with start time at or after 7:30

Mandatory Requirements

Expert 84+ Months: 

Desired Requirements

• 84 Months Demonstrated Experience working with Patient health data including experience in using uniform resource code for assigning service types to patient records in inpatient, outpatient and residential settings.
• 84 Months Demonstrated work experience using National Health Care coding standards like ICD-9 CM/ICD10, NDC, DSM III/IV/V
• 84 Months Demonstrated Experience in analyzing, processing, and loading Medicaid and Pharmacy data into multiple large datamarts (20+ terabyte). 
• 84 Months Demonstrated experience collaborating with developers as a team lead in designing Informatica ETL and database architecture using data warehousing concepts.
• 84 Months Demonstrated experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows.
• 84 Months Demonstrated Experience in SAS codes for conversion into informatica ETL code.
• 84 Months Demonstrated Experience with Informatica Administration and Metadata to generate daily load stats.
• 60 Months Demonstrated Experience analyzing, interpreting, and outputting staff productivity data from Human Resource and payroll records.
• 60 Months Demonstrated work experience implementing Fine Grain Access Control Audit (FGACA)  to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• 60 Months Demonstrated hands-on experience in relational data management disciplines and design and development experience using Oracle technologies

Responsibilities

• Working with Patient health data including experience with admission, discharge and day to day census record, Medicaid transaction processing and Pharmacy data integration.
• Collaborating with developers as a team lead in designing Informatica ETL and database architecture using data warehousing concepts.
• Use Informatica Metadata to monitor and generate daily load stats.
• Implementing Fine Grain Access Control Audit (FGACA) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• Writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows.
• High level experience in Informatica Administration including installation, patching and deployment of Informatica ETL code across all platforms.
• High level experience in Datawarehouse design and architecture, including expertise in Star schema design and Dimensional Data Modeling 

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer