Local only : ETL Developer with ODI | NY |

Hi,

 

Kindly find below Mention JD.

 

Title : ETL Developer

Location : NYC | NY

Duration : 6+ Months

 

We just received this new ETL Developer ., they require ODI as the ETL tool (5 years exp. with ODI). Financial services background.

 

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.

 

Best Regards

Nitesh

Technical Recruiter

P-201-285-8031 * 119 | F- 201-526-6869

APETAN CONSULTING LLC

72 Van Reipen Avenue # 255

Jersey City, NJ 07306

Niteshy@apetan.com

http://www.apetan.com

--
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 http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.