Job Title: Database Architect_Expert - 13049 (Datawarehouse, Informatica, ETL, HIPPA, PHI, Unix, PL/SQL, Testing) Location: Menands, NY/Hybrid Duration: 30 Months Direct ClientJob Description: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. Position Requested Qualifications:
- 84 Months Experience using Informatica 10.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to Oracle and flat files.
- 48 Months Experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleaning, standardization, match and merge with IDQ 8.x or higher.
- 72 Months Work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
- 72 Months Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.
- 72 Months Experience writing complex UNIX scripts to validate and FTP files, and for calling Informatica workflows.
- 72 Months Experience converting complex SQL, PL/SQL (stored procedures/functions), as well as SAS code with Oracle 10g or higher, to Informatica mappings.
- 72 Months Experience in Dimensional Data Modeling for creating logical and physical data models using Erwin.
- 72 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.
Benefits: Salary: $63.44 to $73.44 DOE Hybrid Candidates having valid work permit in US should apply.