Overview
On Site
Hybrid50%
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
ETL
Informatica
IDQ
Health & Human services
OLAP
OLTP
SQL
UNIX
CDC
Job Details
Job Title : ETL Informatica Lead Consultant
Location : Albany, NY
Duration : 18 Months
Client : State of NY
Required Skills:
- Level III- More than seven (10) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
- More than (10) years of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.
- Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.
Desired Skills:
- Seven years or more of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
- Seven or more years of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
- Five or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality.
- Seven years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.
- Seven or more years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
- Seven years or more of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.
- Experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects.
- Experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
- Experience with Health & Human services applications.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.