What are the responsibilities and job description for the ETL Informatica Developer position at All IT Solutions?
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.
Thanks & Regards,
Alister Grove - Recruiter
1 307-655-6106 (#113) | | alister@allitsolutions.us
http://www.allitsolutions.us
https://www.linkedin.com/company/all-it-solutionsus/