OB ID: HBITS-08-14991
Client: Office of Mental Health
Job Title: ETL Developer
Duration in months: 30
Location: Menands, NY 12204
Work Mode: Onsite/Hybrid
Interview Process: Webcasting
Mandatory Documents:
Resume
Passport Copy mandatory for Non USA Citizens
Copy of Visa Stamping Page
Three Professional References
Copy of Driver License (USA Citizens)
Pre-submission Video screening + ID verification required
Quick update on Candidate for the above position
Before we submit the candidate to Client, our team will complete a pre-submission video screening. As part of this screening, the candidate must show valid IDs such as Passport, Green Card, or Visa copy to verify identity and work authorization.
We'll proceed with the screening and move forward with client submission only after this step is complete. I'll update you once we're done.
Requested Qualification:
84 Months Experience using Informatica Powercenter 10.5.x or higher and Informatica Intelligent Data Management Cloud 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 analyzing 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 (FGACA) in an Enterprise Data Warehouse environment to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
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.
Bachelor's degree in computer science, business intelligence, information science or related field.