Source description
About the role
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
More at 3B Staffing