Five Cubes, Inc.
Database Architect_Expert
Five Cubes, Inc., Albany, New York, us, 12237
Job Title: Database Architect_Expert - 13049 (Datawarehouse, Informatica, ETL, HIPPA, PHI, Unix, PL/SQL, Testing)Location: Menands, NY/HybridDuration: 30 MonthsDirect Client
Job 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 DOEHybridCandidates having valid work permit in US should apply.
Job 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 DOEHybridCandidates having valid work permit in US should apply.