N2S/PJS/10-12-11/003..........ETL Architect

Job Title: ETL Architect

Location:  NYC, NY

Duration:  6+ Months

Rates: $60-63/hr C2C (MAX)

 

Experience Level        6/+ yrs IT

 

Skills:       Database Skills, ETL Tool Architecture, BI Tool Architecture, OS Knowledge on Unix, Linux, MS, Data Modeling Concepts & Tools, Oracle Modeling, Oracle Architecture, ETL Tool Application Testing, ETL Tool Application Development, ETL Tools (Informatica)

 

Job Role / Responsibilities: The DW Architect will work with the project team comprising of subject matter experts and technologists in the design and construction of a securities lending data warehouse.

 

This is a senior-level position and candidate are expected to have excellent skills in the following areas:

• Oracle architecture solution designing and development of data warehousing based on a Oracle repository;
• Data modeling and design considerations for analytical systems including reports and dashboards;
• Designing, reviewing and optimizing Star, Snowflake and hybrid data models;
• Advance data architecture experience with normalized and de-normalized data model structures in heterogeneous environment;
• Writing, executing and debugging SQL queries to perform tuning and optimization of BI implementations;
• Optimize the physical models for typical warehouse ETL and query loads;
• Performance tuning;
• Database administration, tuning and space management;
• Recommend and implement database partitioning and index strategies;
• Reviewing data models and recommending fixes ;
• Experience in designing data warehouses for capital markets or like areas is highly desirable;

Project Details   The initiative entails build of a securities lending data warehouse that will source data from existing lending systems and ancillary sources. Exploitation of the warehouse will be via means of a BI suite of products.

 

Warm Regards

Paul James Singh

Business Relationship Manager

Net2Source Inc. {MBE Certified – NMSDC | SBE Certified (State of NJ)}

Direct: (201)680-0782 | Cell: (713)359-9206 | Fax: (201)221-8131

Email: paul@net2source.com | Website: www.net2source.com

LinkedIn: http://www.linkedin.com/in/pauljamessingh

As iron sharpens iron, so one man sharpens another - Proverbs 27:17

** Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills 1618 Title III passed by the 105th U.S.Congress, this mail cannot be considered Spam as long as   we include contact information and a method to be removed from our mailing list. To be removed from our mailing list, please reply with "REMOVE" in the subject line and your email address in the body. Include Complete Address and/or Domain/Aliases to be removed. We sincerely regret any inconvenience **