Thursday 14 July 2011

[Outsource:53267] Need Sr, ETL Developer.....(GC OR CITIZENS/EADs only ………………..)

Hi Associates,

 

Please let me know fi you have any consultants for below Job need.

 

GC OR CITIZENS/ EADs only ………………..

 

Position: Sr, ETL Developer

Duration: 3 months contract to hire

Location: Dublin, Ohio

 

Job Description

Role/Responsibilities/Key Tasks:

         Design and develop ETL data flows and processes based on requirements for the data warehouse and application interface

         Design, develop and support ETL processes for data staging, extraction, transformation, and loading of fact tables, data cleansing, updating type 2 slowly changing dimension tables, automating ETL processes.

         Provide hands-on development, unit test, system test and support for ETL processes, including bug fixes

         Collect, organize and generate new documentation for ETL projects including technical specifications, ETL test scripts, change control, implementation checklists, data flow diagrams.

         Collaborate with Solutions Architect and Data Architect to understand business requirements and data model

         Collaborate with Data Architect and DBA team to optimize ETL performance

         Follow and improve ETL strategy, "best practices" and standards as they relate to ETL in the environment

         Assist with Informatica repository administration services and enforce ETL object reusability

         Production Support for ETL processes and Data Warehouse

 

 Non-Technical Skills:

         Strong interpersonal skills, speaks clearly and concisely in meetings and conversations, effective listener, expresses ideas clearly in writing, works well with others in a group.

         Understands key factors impacting the business.  Integrates information of multiple business factors (financial, marketing, etc.) to create solutions that are in line with company goals.

         Strong strategic skills, the ability to lead in the adoption of ETL technologies, standards and best practices.

         Ability to handle difficult situations; work as a team to resolve issues and to help "firefight" during crises situations.

         Interacts with internal and external clients

         Recognizes business opportunities in a variety of situations, anticipates and responds to clients' needs by seeking and acting on their feedback.

         Ability to collaborate effectively with a broad base of business and technology associates

         Excellent analytical and problem-solving skills.

         Excellent written and oral communication skills

         Excellent organizational and time management skills

         Demonstrated ability to work both independently with minimal supervision and within a team

         Demonstrated ability to handle multiple assignments simultaneously

         Travel as necessary

 

Competency Requirements:

         Problem Solving/Decision Making

         Functional Expertise

         Initiative

 

Job Requirements/Technical Skills

This role requires a broad understanding of data technologies, including ETL, OLAP, OLTP and general modeling practices, as well as experience in data warehousing.

         In-depth knowledge of and experience with Informatica PowerCenter v8.6.1 as a designer, developer, and administrator

         High proficiency in understanding relational, star schema and dimensional data models.

         Proficiency in Oracle 11GR2 SQL including optimizing SQL statements and the use of SQL editors

         Understands dimensional modeling (star schemas/ROLAP, OLAP, MOLAP)

         Demonstrated ability with Microsoft Office 2010 (Outlook, Word, Excel), Visio, Erwin

         Experience with Oracle Financial Analytics, DAC, RPD –desired

         Experience with Oracle Hyperion Essbase  v11 (EAS, EIS, Maxl scripts, load rules, calc scripts) - desired

         Expertise in PL/SQL, stored procedures, Unix shell scripting – desired

 

EDUCATION QUALIFICATION:

Required Minimum: Bachelor Degree in Computer Science or similar discipline

 

EXPERIENCE:

Required Minimum:   3-5 years of experience in ETL development and Data Warehousing.

 

 

 

 

 

 

Thanks and Regards

Geetha N

Sr Technical Recruiter 

 

14175 Sullyfield Circle, Suite # 400,Chantilly, VA 20151, U.S.A

Ph: 703-953-2995 Fax: 703-995-0830

Email:geethan@usmsystems.com Yahoo IM geetha.softit1

Ranked No.10 in the Washington DC area-Washington Business Journal, 2010;

Smart CEO Award Winner By SMART CEO Magazine, Baltimore, U.S.A­­­­­­­­­­­­­­­­­­­­­­­­­­­­­;

Inc5000  Recognized Fastest growing private company in U.S.A

                                             Office Locations: Washington D.C| Atlanta | Boston |Hyderabad, India

 

--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
 
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.

You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Outsource

No comments:

Post a Comment