Search Jobvertise Jobs

Database Architect - Senior
Email this job to a friend

Report this Job

Report this job

Incorrect company
Incorrect location
Job is expired
Job may be a scam

Apply Online
or email this job to apply later

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

Apply Online
or email this job to apply later

Search millions of jobs


Jobs by Title | Resumes by Title | Top Job Searches
Privacy | Terms of Use

* Free services are subject to limitations