We are looking for a hands-on, agile, and result-oriented Data / ETL Architect & Risk Data Senior Developer Consultant for a client engagement in the financial industry preferably Risk Technology. If you are available and interested, or know someone else who may be looking, please contact me at [email protected]
Title: Data / ETL Architect & Risk Data Senior Developer
Location: Jersey City, NJ
Type: CONTRACT C2C, W-2
Rate: $ 80/hr
Duration: 6 months
Job ID: 0119-001DEA
The consultant is expected to primarily responsible for the Data &ETL architecture, Design and Development for data integration efforts surrounding the Risk & Compliance systems.
Responsibilities:
- Establish, maintain and enforce ETL architecture design principles, techniques, standards and best practices. Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.
- Collaborate with Business Analysts, and DBAs to understand business requirements, data, and optimize ETL performance.
- Develop complex ETL mappings on Informatica 9.1 platform as part of the Anti Money Laundering and Risk Data integration efforts.
- Lead team of junior ETL developers of varying experience levels in building and supporting ETL processes for systems.
- Develop and deploy utilities on Informatica 9.1 platform that assist in the daily maintenance of the ETL platform and automation of the jobs.
- Performances tune the workflows on 9.1 platforms as part of the upgrade and development.
- Provide hands on support for production ETL processes
Requirements:
- Requirements Overall 8+ years of ETL methodology and data design experience
- Expert Knowledge in Informatica 9.1 development and able to trouble shoot the issues independently.
- Experience with Oracle 10 / 11g.
- Experience working with Very Large Databases and Data Warehouse environments.
- Experience with Redhat Linux Server. Proficiency in UNIX shell scripting is needed.
- Minimum 8 years total ETL development experience. Expert level development using Informatica PowerCenter 9.1
- 5+ yrs Oracle experience * SQL (must be very strong in SQL) - Oracle 10g experience is mandatory.
- 3+ years Oracle experience * PL/SQL
- 3+ years experience with Linux (Preferably Redhat) and Shell Scripting.
- Good working knowledge of XML and schemas in Informatica PowerCenter.
- Looking for candidates who have recently worked in the financial domain for a long time - (their last 3-4 assignments at least;) using heavy design, ETL (Informatica 9.x) and database (Oracle10, 11g).
Preferred Skills:
- Prior experience in building the Compliance Data Repository for Risk data integration.
- Working knowledge of dimensional and relational modeling required.
- Financial compliance Industry experience pertaining to Anti Money Laundering, Trade Surveillance
- Knowledge of Business Objects software and Universes.
- Good to have Knowledge of Java Script, HTML, J2EE concepts
About MicroAgility: (Inc 500 honoree in 2008):
MicroAgility is a business and technology consulting company. Our experienced, agile, and result-oriented consultants partner with organizations to solve their pressing challenges. To review our other positions, please visit us at http://www.MicroAgility.com/Careers. Please also visit our Blog.MicroAgility.com for insight, analysis, and job openings.