800 N. Pearl St. Room #229 , Menands, Ny , 12204
Rate: Based on experience
Total Positions: 1
Preferred Hardware: HP
Preferred Software: Oracle and Informatica
Work Hours: 8 hour days with start time at or after 7:30
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
Technical Architect - Technical expert centered around a technology, technologies or a portfolio of applications- Designing and implementing Information Technology solutionsExpert84+ Months: Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field
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).