Hello,
Hope you're doing great.
Please find the below requirement. Thanks.!!!
Position: ETL Developer
Location: Columbus, OH
Duration: 10 months
IN PERSON INTERVIEW NEEDED
10+ Years' Experience Required.
BWC 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.
BWC'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.
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 Ohio BWC 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
Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
10 or more years of experience in design, development, modification and
testing of ETL processes
Required
10
Years
10 or more years of experience developing ETL processes using tools such as
Pentaho, Informatica, IBM InfoSphere DataStage, Talend etc.
Required
10
Years
5 or more years of software development experience with Oracle databases
Required
5
Years
5 or more years of experience developing ETL processes against
dimensional/star-schema based data structures including fact tables
(commonly referre
Required
5
Years
Experience developing and modifying ETL processes with Pentaho
Desired
1
Years
Experience scheduling ETL processes
Desired
3
Years
Experience with Cognos business intelligence tools
Desired
Software development experience with Oracle RDBMS 11g
Desired
1
Years
Software development experience with IBM DB2/UDB
Desired
Experience developing ETL against normalized data structures (commonly
referred to as Inmon)
Desired
5
Years
Experience using Oracle SQL*Plus, Toad, Oracle PL/SQL Developer
Desired
3
Years
Experience with Red Hat Enterprise Linux
Desired
Experience developing and modifying scripts in a Linux or Unix environment
Desired
1
Years
.Experience in measuring and tuning the performance of batch systems in a
Linux or Unix environment
Desired
1
Years
Ability to quickly adapt to changes, enhancements, and new technologies
Desired
2
Years
Skill in the use of organizational tools & methods (MS Excel, MS Word, MS
Outlook, VISIO, Clarity)
Desired
2
Years
Knowledge of property and casualty insurance systems
Nice to have
Knowledge of Ohio BWC business model and processes
Nice to have
Acha Ayyappa
Integrated Technology Services, Inc.,
Direct: 703-246-1342 || Email: <mailto:a...@its-incorp.com>
a...@its-incorp.com || Gmail: <mailto:spkayya...@gmail.com>
spkayya...@gmail.com
----------------------------------------------------------------------------
----------------------------------------------------
2201 Cooperative Way, Suite 600, Herndon VA 20171 || www.its-incorp.com
----------------------------------------------------------------------------
----------------------------------------------------
--
You received this message because you are subscribed to the Google Groups
"American Vendor--IT Consulting" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.
