Job Description :
Hi,
Kindly find below JD,

Position: ETL/Informatica Engineer
Location: Parsippany, NJ
Length: 3 month+ Contract

Interview: Phone screen, face to face interview. MUST BE LOCAL CANDIDATES. NO SKYPE

*Must Have: *
MUST HAVE EXCELLENT COMMUNICATION SKILLS!!
Just implemented Oracle ERP – Financial EBS 12
Working on most recent version of Informatica currently
Integrating informatica with Oracle and other systems
Must understand/know informatica and be able to run test scripts and understand the business process
* Testing – end to end *
Techno Functional Role
Must be professional/Mature – will be the go to person
Assisting with integrations
Working with the Head of Data Integration – Kalyani Polturi
o Needs someone that can develop code
o Understand business process
o End to end testing
o Robustness and integration: how do you test, what kind of environment, etc
o Data encryption
Environment:
Microsoft Windows
SQL – J Server
Now integrating Oracle and Data warehouse (SQL Server SharePoint)
Outsourced logistics – information is loaded into their systems – critical process – having the end to end experience is imperative


Job description
Our Client in Parsippany NJ is seeking consultant for a 3 month contract to start:
An ETL engineer who has:
o In-depth knowledge of Informatica.
o Understands how to design and implement ETL processes in a maintainable way
o Able to create batch files/scripts to support non-informatica based file transfers etc.
o Understands how to work with data encryption / decryption and secure file transfer feeding from and into the databases and external environment
o Able to create merge and update scripts for master table maintenance (understands how to refresh tables in an efficient and effective way
o Understands and knows how to test and quality check the developed processes
o Not only building the integrations with Informatica but also needs to be able to quality check and test thorough the solution.
o Document the development processes and business rules (outside of the Informatica tool) and using Visio and design templates.
o Able to make robust solution which don’t need maintenance on a daily base.
Meaning build solutions needs to be robust enough to handle simple and complex errors and self-recovery
Hence solutions need to work without a person monitoring all interfaces on a day to day base, but get alerted when something goes wrong and needs attention of a specialist.