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-1715, ta...@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.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------