|
Search Jobvertise Jobs
|
Jobvertise
|
Database Architect - Senior Location: US-NY-Menands Email this job to a friend
Report this Job
Position Name: Database Architect Job ID: 02-11362 Duration: 30 Months Location: Menands, NY Primary Skills: - 72 Months Experience using Informatica 8.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.
- 36 Months Experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher.
- 60 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)
- 60 Months Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.
- 60 Months Experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows
- 60 Months Experience converting complex SQL, PL/SQL (stored procedures/functions), as well as SAS code with Oracle 9i, 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
Avenues International
|