*ETL Developer. *
*Columbus, Ohio*
*Candidates MUST be able to do an in-person interview next week.*
*MUST HAVE 10+ YEARS EXPERIENCE AND SHOULD BE LOCAL*
ETL Developer. Our Columbus, Ohio client is looking for an ETL Developer
to work as a contractor to support implementing a new system, which is
shifting the data warehouse and reporting infrastructure from DB2/Hyperion
to Oracle/Cognos. The new system will have a transaction data store (TDS),
operational data store (ODS) and a newly designed Oracle Enterprise Data
Warehouse. Extract, transform and load (ETL) jobs will be designed,
developed and tested to move data between these various databases.
During a given day, this position will be expected to:
• Work with Business Analysts and potentially business customers to verify
requirements
• Follow design documents involving source and destination databases
• Interpret design documents to understand mapping and transformational
requirements
• Design, develop and test ETL processes using Pentaho or comparable ETL
tool to move data to/from relational and star-schema based data structures.
• Optimize ETL processes to fit in a desired time frame
*Mandatory Skills:*
• 10 or more years of experience in design, development, modification and
testing of ETL processes
• 10 or more years of experience developing ETL processes using tools such
as Pentaho, Informatica, IBM InfoSphere DataStage, Talend etc.
• 5 or more years of software development experience with Oracle databases
• 5 or more years of experience developing ETL processes against
dimensional/star-schema based data structures including fact tables
(commonly referred to as Kimball).
*Desired Skills:*
• Experience developing and modifying ETL processes with Pentaho
• Experience scheduling ETL processes
• Experience with Cognos Business Intelligence tools
• Software development experience with Oracle RDBMS 11g
• Software development experience with IBM DB2/UDB
• Experience developing ETL against normalized data structures (commonly
referred to as Inmon)
• Knowledge of property and casualty insurance systems
• Knowledge of client business model and processes
• Experience using Oracle SQL*Plus, Toad, Oracle PL/SQL Developer
• Experience with Red Hat Enterprise Linux
• Experience developing and modifying scripts in a Linux or Unix environment
• Experience in measuring and tuning the performance of batch systems in a
Linux or Unix environment
• Skill in the use of organizational tools & methods (MS Excel, MS Word, MS
Outlook, Visio, Clarity)
• Ability to quickly adapt to changes, enhancements, and new technologies
Thanks,
*Zaid Mohammed*
IT Recruiter
Seven Hills Software Technologies Inc
Carnegie Office Park, Building Six
800 N. Bell Avenue, Suite # 255
Carnegie, PA 15106
Office: 412-450-1316 X 112| Fax: 877-745-4811
Email: z...@shstinc.com
--
--
***************************************************************************************
For all SAP related tutorials,Articles,Faqs,Tips
www.sapbrainsonline.com
****************************************************************************************
You received this message because you are subscribed to the Google Groups
"sapbrains" group.
To post to this group, send email to sapbrains@googlegroups.com
To unsubscribe from this group, send email to
sapbrains-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sapbrains?hl=en
---
You received this message because you are subscribed to the Google Groups
"sapbrains" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sapbrains+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
