*Greetings from SoftSages Technology!!* Hope you are doing good!!!
*I am reaching for an urgent need of Senior ETL Developer in Ohio my direct client, consultant should be able to attend in-person round of interview.* *Please send the resume at [email protected] <[email protected]> or Call at | 484 402 7869 X 103 |* *Role : Senior ETL Developer* *Duration : 8+ months* *Work Address : 30 West Spring Street, Columbus, OH 43215.* *MODE OF INTERVIEW - Phone and In-Person* *INTERVIEWS SCHEDULED ON February 18, 19, 20.* *Short Description:* BWC is looking for a Programmer 5 to support 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. *Complete Description:* 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 *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 *Thank you, and have a great day.* *Sujith.M* SoftSages LLC | A e-verified, MBE certified corporation. *| **[email protected]* <[email protected]>* | | **484 402 7869 X 103* * |* In case of my unavailability, you can reach my manager, Aman at *| *484 604 0603 *| | *[email protected] *|* -- You received this message because you are subscribed to the Google Groups "International SAP Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/international-sap-projects. For more options, visit https://groups.google.com/d/optout.
