Urgent Requirement for ETL Developer

0 views
Skip to first unread message

Hariom Sharma

unread,
Sep 13, 2011, 6:56:41 PM9/13/11
to harishar...@gmail.com, har...@hevar.com

ETL Informatica contract role

Wilmington, DE

6 months

Phone then F2F interview

 

Application ETL Developer (for Mumps/ Profile project - Blackhawk)

 

Job Summary:

The Application ETL Developer is responsible for supporting ING’s strategic initiatives to acquire, retain, and develop profitable customer relationships. This involves implementing and maintaining a corporate wide data warehouse and specific data marts for individual departments.

The developer will primarily be responsible for development scripts and procedures to extract data from source systems, transform the data (i.e. standardizing, cleaning, de duping, etc), and then map and load the data into the corporate data warehouse.

The developer will also be responsible for optimizing any processes, programs, and functions to improve data quality, data security, and data consistency.

 

Candidates with any exposure to, knowledge of or experience with Mumps / Profile would get an instant look! 

 

Essential Functions:

·          Extract data from source systems

·          Transform data via standardization, cleaning, data repair, matching, and deduping

·          Manage multiple data sources including internal, external, and 3rd party source system data

·          Manage all technical aspects of the ETL process

·          Performance tuning of ETL processes

·          Assist in developing feeds to departmental Data Marts

·          Ability to be a strategic business partner/consultant for data warehouse development

·          Ensure the data warehouse is able to provide required information to all departments

·          Ensure data warehouse is able to provide highly targeted lists of customers based on any data attributes, including demographic attributes, transactional behaviours, and event triggers

 

Experience & Qualifications:

·          Extensive working knowledge of Oracle Database, Relational and Dimensional Data Modeling, and Full Life Cycle Design and Application Development

·          In depth knowledge of the Informatica tool

·          Extensive SQL, PL/SQL, Stored Procedure, Packages, and UNIX scripting skills.

·          Experience creating and maintaining an extraction, transformation, and loading process (ETL) from source systems into a data warehouse, mart, or both

·          Working experience with SQL performance tuning

·          Knowledge OLAP application development

·          At least 5 years of experience in database systems

·         Pprofile / Mumps, PeopleSoft Financials and/or  Hyperion experience (would be a big plus!).

--

-----------------

Thanks and Regards,

Hariom Sharma

Technical Recruiter

 

Hevar Systems,Inc

1825,W Walnut Hill Lane,Suite,120 Irving, TX 75038 
  Fax: 866-542-2082
E-mail:   har...@hevar.com

Website: www.hevar.com  

Gtalk:    harishar...@gmail.com

In case I am not available you can reach, Tarun @ 972-200-1715ta...@hevar.com

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Under Bill s.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 remove link for removal from our mailing list. To be removed from our mailing list, reply with remove in the subject heading and your email address in the body. Include complete address and domain to be removed. Pursuant to Federal law, if you do not wish to receive future email messages from us, please reply with "remove" to the same id.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Reply all
Reply to author
Forward
0 new messages