Overview
Skills
Job Details
ETL Informatica Developer
Duration: 24 months
Location: Albany, NY (2-3 days remote every week)
Client: State of New York
Note: Candidates must share 3 references and a copy of their Visa & Passport for submission
Job Description:
1. | 60 months of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases. |
2. | 60 months of experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality. |
3. | 60 months of 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. |
4. | 60 months of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality |
5. | 60 months 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. |
6. | 60 months of 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. |
7. | 60 months of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL process |
8. | 60 months of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes. |