ETL Developer ODI as the ETL tool (5 years exp. with ODI). Financial services background.
Long Term Contract open ended contract
Location: NYC, NY
Interview Process – phone then face to face interview (NO SKYPE)
Compliance Systems – ETL Developer
ODI ETL Developer for Compliance Systems Division primarily responsible for analyzing, validating and manage requirements, flows and adapting strategic business needs and functional processes into horizontally integrated data management solutions in line with the Firm's overall Data Governance strategy.
ODI (ETL) developer will own the technical understanding of the existing and future database schema and related programs used across all products and business lines. Project data deliverables include gathering of data requirements, data flow diagrams, data sourcing plans, data privacy/security architecture, data integration specifications, design, development, testing, status updates and implementation.
The individual will work with business and IT groups to design a data integration workflow design that provides for the extracting, loading and transforming of data, primarily for compliance reporting and analytics using Oracle ODI. The Developer must be capable of working in a collaborative environment to support rapid development and delivery of highly demanding projects.
Responsibilities:
Designing ETL interfaces and packages from several data sources
Dimensions, Hierarchies, Fact Tables
Experience with Oracle ODI
Development, ETL designs, datastores, etc.
Strong understanding of relational databases and Data warehousing concepts
Strong PL/SQL knowledge
Nightly refresh of data load plans
Hands on experience with Unix/Linux
Experience with requirements gathering process with Business Analysts and Users
Experience working on troubleshooting and performance tuning of ETL interfaces
Experience creating data validation test cases, etc.
Experience with Star and Snowflake schemas
Draw out, analyze, validate and manage requirements, flows and deliverables for projects.
Ensure functionality of product meets with business requirements and expectations.
Key Skills:
Ability to independently manage, organize and prioritize multiple tasks and responsibilities.
Very Strong understanding of SDLC
Strong understanding of job Schedulers like Autosys
Strong SQL skills across various databases including Oracle, SQL Server and DB2.
Database: ORACLE, SQL Server, DB2
Knowledge of database analysis tools like TOAD, SQL Developer, etc.
Strong organizational, analytical and design skills.
Excellent oral and written communication skills.
Other Skills (Nice to Have):
Knowledge of Actimize product suite, Fircosoft – a plus
Qualifications:
Proven experience in data analysis, designing and development of ETL
Demonstrated experience with IT requirements development; systems design, and integration
Expert analytical skills. Able to critically evaluate the information gathered from multiple sources, decompose high-level information into details, abstract up from low-level information to a more general understanding, and distinguish solution ideas from requirements.
A self-starter can manage multiple responsibilities without close supervision.
A team player and work independently.
Experience working with a Global team.
Experience and Education:
Bachelors' degree in computer science or other engineering discipline.
At least 5 years of experience in ODI ETL development
You received this message because you are subscribed to the Google Groups " c2c jobs usa" group.
To unsubscribe from this group and stop receiving emails from it, send an email to c2cjobsusa+unsubscribe@googlegroups.com.
To post to this group, send email to c2cjobsusa@googlegroups.com.
Visit this group at http://groups.google.com/group/c2cjobsusa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment