Title: ETL Developer
Location: Miamisburg, OH
Length: 1 Year+
Background
Client is a provider of Data Warehousing technologies and consulting services to numerous industries worldwide and is headquartered in Miamisburg, Ohio. The Teradata Enterprise Data Warehouse (EDW) team is an organization chartered to utilize Teradata products and services to deliver information and analytic capabilities to all Teradata business functions and external stakeholders. The EDW team is comprised of Data Warehouse consultants with experience delivering business intelligence solutions and is looking to augment current team with an ETL Development Consultant.
Role Description
The ETL Development Consultant specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This individual must have the skills necessary to understand the overall data warehouse architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client (in this case the ETL tool is SAP's Data Services – Data Integrator). The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database.
Key Areas of Responsibility
· Capture ETL Requirements.
· Design, develop, and test processes for extracting data from legacy systems or production databases (this assignment: source system will be Oracle ERP applications).
· Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse.
· Design, develop, and test processes for loading initial and cyclical data into a data warehouse.
· Design the processes to meet service level agreements for data timeliness and frequency.
· Determine which data elements are historic and the retention period for historic data.
· Determine data growth trends and peak business periods.
Skills
· 2+ years of experience with SAP Data Services: Data Integrator ETL tool.
· 5+ years of experience in BI and Data Warehousing
· Experience/Familiarity with Teradata DBMS and utilities (BTEQ, MLOAD)
· Experience working with off-shore developers a plus
· Experience with SAP Business Objects BI Tools high
| Skill Category | Skill Mapping | ||
| Tools – ETL – SAP BO Data Integrator | Primary Skill | ||
| Software Development Skills | Primary Skill | ||
| Teradata RDBMS | Secondary Skill | ||
| Tools – Job Control and Scheduling | Secondary Skill | ||
| Tools – SAP Business Objects BI Tools | Secondary | ||
| Tools – ERWIN Data Modeling | Knowledge | ||
| Oracle ERP Application Knowledge | Knowledge |
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