Dear
We have an urgent opening for ETL Informatica Engineer I have sent you a job description Please go through it and let me know if you are comfortable with it and also send me your consultant's updated resume ASAP. If you are comfortable with the profile please revert me back on the same email.
Position: ETL Informatica Engineer
Location: Parsippany, NJ
Length: 6+ Month contract
Interview: Webex video interview, then Onsite interview.
MUST HAVE: ETL, Data Warehouse, SQL Server, Informatica, coding, Test Scripts,
DESCRIPTION:
- 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
- Needs someone that can develop code
- Understand business process
- End to end testing
- Robustness and integration: how do you test, what kind of environment, etc.?
- 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
"HR Job Description" (the notes above are what they are looking for)
Formal Write up of role:
- We are developing a financial data warehouse connecting the Oracle ERP system with a SQL*server/ SharePoint analytics Data Warehouse. For Data integrations we use Informatica. Oracle runs in a LINUX environment. Rest is all Microsoft based.
- The ETL consultant should work under supervision of Manager Data Integration to create and maintain all ETL process between oracle and the data Warehouse. Various business rules need to be build-into the ETL environment.
- It's a very small team – meaning a person who understands end-to-end integrations and not just the Informatica tool.
Some aspects I am looking for:
An ETL engineer who has:
o In-depth knowledge of Informatica which is obvious.
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.
Rashee Kapasia | Technical Recruiter | Apetan Consulting LLC
Tel:201-620-9700* 131 | Fax: 201-526-6869 |
Mail : 72 van reipen ave pmb#255, Jersey City, NJ 07306 |
Corp. Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 |
rashee@apetan.com | www.apetan.com |
G-Mail/yahoo: rasheeapetan131
Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at remove@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment