| SLG - 19 - 9517-Sr. Informatica Consultant-Albany, NY-Onsite at Albany, New York, USA |
| Email: [email protected] |
| From: Srikanth Vanam, Sligosoft [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Sr. Informatica Consultant position with our client. Role: Sr. Informatica Consultant Location: Albany, New York Duration: 30 Months Job ID: SLG - 19 - 9517 Client: NY State Respond by Date: 05/24/24 5:00 PM Description Support the Data warehouse Informatica PowerCenter ETL (Extract, Transform, Load) processes, Informatica administration, and redesign and implementation of current and future OMH projects. Duties Analyse and translate patient health data business requirements into ETL code. This includes admission, discharge, and day to day census records, financial, billing, human resource, payroll, Medicaid, and Pharmacy data. Participate in Datawarehouse design and architecture planning, Using Kimball methodologies of Star schema design and Dimensional Data Modelling techniques. Collaborate with developers as a team lead in designing Informatica PowerCenter ETL and database architecture using advanced data warehousing concepts. Extract and interpret Informatica Metadata repository data. Implement Fine Grain Access Control Audit (FGACA) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI). Analyse and code complex UNIX scripts to validate and ftp files and monitor Informatica workflows. Perform Informatica Administration including installation, patching and deployment of Informatica ETL code across all platforms. Mandatory Requirements Experience (10+ Years) Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. Requirements This is an 100% Onsite 84 Months Experience using Informatica PowerCenter 9.6.x or higher in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings. 84 Months Experience with Informatica PowerCenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository optimization. 84 Months Experience analysing and converting, heterogenous Health systems data, including admission, discharge, census, financial, billing, human resource, payroll, Medicaid, and Pharmacy data into complex ETL code. 84 months Experience in relational data management disciplines and design and development experience using Oracle technologies including designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment. 60 Months Experience working with UNIX and or LINUX Operating Systems. 60 Months Experience collaborating with developers as a team lead in designing PowerCenter ETL and database architecture using advanced data warehousing concepts. Bachelors degree in computer science, business intelligence, information science or related field. Rsum Please submit copy of degree. Thanks Srikanth Vanam Keywords: information technology Idaho New York SLG - 19 - 9517-Sr. Informatica Consultant-Albany, NY-Onsite [email protected] |
| [email protected] View all |
| Wed May 22 21:13:00 UTC 2024 |