ETL Informatica Developer

Title: Senior ETL Informatica IDMC Developer/Engineer position

Location: Jersey City NJ 07302 - (Hybrid Position - 3 Days Onsite and 2 Days Remote in a week)

Duration: Long term contract

Client Interview Process: Web-Ex/MS Tems In-Person/Onsite interview

As a Sr. ETL/Informatica IDMC Developer/ Engineer you will have:

Informatica IDMC/Power center 9.x/Oracle/DB2/Unix/Autosys

Strong Informatica ETL 8 years experience with Oracle Exadata PL/SQL and UNIX background and good communication skills.

Experience with custom or structured ETL design implementation and maintenance

Experience in working on fact and dimension data model.

Experience in data extraction from DB2 and Oracle

Experience in parsing flat files and apply complex logic to process the data

Develop implement and maintain job schedule for automated ETL processing error handling error notification and logging.

Ability to run complex queries based on requirements and writing PL/SQL stored procedures.

Strong Unix experience in writing shell scripts and convert existing TCL scripts into shell scripts for preprocessing files.

Candidate should be able to work independently with minimal guidance and complete the tasks in timely manner.

Financial domain experience is must

Experience in full development lifecycle within Agile environment and ability to work with others in a strong team environment

Strong Informatica ETL 8 years experience with Oracle Exadata PL/SQL and UNIX background and good communication skills.

Experience with custom or structured ETL design implementation and maintenance

Experience in working on fact and dimension data model.

Experience in data extraction from DB2 and Oracle

Banking Experience

Required Skills and Experience:

ETL-Informatica - Min. 10 Years

Informatica IDMC: 5 Years

Informatica PowerCenter: 5 Years

Data Extraction- 5 Years

API: 2 Years

Banking domain experience is highly preferred.