Senior ETL Informatica IDMC Developer/Engineer

Senior ETL Informatica IDMC Developer/Engineer position

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

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

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.

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

Please apply on - sam@peopleconsultancyspl.com