ETL Developer - Columbus, OH

PROGRAMMER (ETL Developer) consultant

Location: Columbus, OH

Duration: 1 Year +

 

Interviews planned for September 20-25

(Please Note: If your candidate is not available to interview at this time, please don’t apply)

 

Projected Start Date:  October 7, 2013.

 

 

Background

Customer is  implementing a new Claims, Policy and Billing system.  This new implementation is shifting our Data warehouse and Reporting infrastructure from DB2/Hyperion to Oracle/Cognos.  The nature of our data is also changing, as data elements are changing purpose and semantics as part of the transition.

 

Customer’s 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.

 

The contractors selected will be working for Customer as a Programmer/ ETL Developer in support of the Data Warehouse project. This will include:

  

Skill Sets

 

Required

 

·         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

 

·         Experience developing and modifying ETL processes with Pentaho

·         Experience scheduling ETL processes

·         Experience with Cognos business intelligence tools (It may say desired – but it is required)

·         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 Ohio BWC business model and processes (very helpful)

·         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

 

Typical Daily Activities:

 

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.

 

Schedule:

 

·         Normal business hours (between 8:00 AM and 5:00 PM) Monday through Friday.

 

---

Bala

Accounts Manager

SSAI Technologies LLC | Board: 908 450 9465| Fax: 908 842 0244 | www.ssaitech.com | Email: bala@ssaitech.com |  bala.ssaitech@gmail.com |http://ssaitechnologies.blogspot.in/