The Role
Lead ETL and data architecture for AML, trade/sales surveillance, and compliance data repositories. Design and develop complex Informatica PowerCenter 9.1 mappings, enforce ETL architecture standards, tune performance, automate and maintain ETL utilities, collaborate with BAs and DBAs, provide production support, and mentor junior ETL developers.
Summary Generated by Built In
Company Description
Job Description
Position Senior Developer ( Data/ETL Architect & Risk Data/AML) - #5792
Duration: 9 months+
Location: Jersey City, NJ
Job Responsibilities:
- Risk Management Architect / Senior ETL developer works primarily on the data needs for the Anti Money Laundering (running on Mantas platform) , Trade Surveillance, Sales Surveillance, Complaince Data repository and various reporting applications.
- Looking for candidates worked in financial domain for long time - last 3-4 assignments atleast; last three long assignments using heavy design, ETL (Informatica 9.x) and database (Oracle10, 11g).
Required Skills:
- 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).
- Total IT Experience of Years Required: 10+ years
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
- Required Education: Bachelors degree in Engineering / Management
Job Description:
- Primarily responsible for the Data &ETL architecture, Design and Development for data integration efforts surrounding the Risk & Compliance systems.
- 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 platform as part of the upgrade and development.
- Provide hands on support for production ETL processes
Skills Required
- 8+ years ETL methodology and data design experience
- Expert development experience with Informatica PowerCenter 9.1
- Oracle 10g / 11g experience
- Strong SQL skills (Oracle) — 5+ years
- PL/SQL development — 3+ years
- Experience with Very Large Databases and Data Warehouse environments
- Red Hat Linux experience and UNIX shell scripting — 3+ years
- Good working knowledge of XML and schemas in Informatica
- Recent and sustained financial domain experience (AML, trade/sales surveillance) across multiple assignments
- Total IT experience of 10+ years
- Bachelor's degree in Engineering or Management
- Prior experience building Compliance Data Repository / Risk data integration
- Dimensional and relational modeling knowledge
- Financial compliance industry experience (Anti Money Laundering, Trade Surveillance)
- Knowledge of BusinessObjects and Universes
- Familiarity with JavaScript, HTML, J2EE
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
STEM Xpert is a consulting engineering firm recognized in the engineering industry for its commitment to client service and passion for excellence. The firm provides specialized professional consulting services in the fields of science, technology, engineering, and mathematics (STEM).
