ETL Developer - In person interview - Direct Client
*ETL Developer - * *In person interview - Direct Client **Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com s...@cncconsulting.com * *Job Title: ETL DeveloperLocation: Richmond, VADuration: 6 monthsDirect Client PositionIn person interviewRate: $55/hr on C2CVDH IS IN NEED OF A HIGHLY SKILLED ETL DEVELOPER/SYSTEMS ANALYST WITH A STRONG BACKGROUND IN SCALABLE, HIGH QUALITY, AND HIGH PERFORMANCE BUSINESS INTELLIGENCE (BI) DASHBOARDS AND RELATED APPLICATIONS BUILT USING ORACLE AND OTHER BI TECHNOLOGIES. AS AN ETL DEVELOPER/ANALYST THIS CANDIDATE WILL BE PRIMARILY RESPONSIBLE FOR DEVELOPING ETLS TO PERFORM LOADING, SANITIZATION, AND DIMENSIONAL MODELING OF DATA FROM MULTIPLE SOURCES. THE DEVELOPER WILL ALSO CONTRIBUTE TO BUILDING THE BI DASHBOARD AND ASSOCIATED REPORTS, REQUIRING WRITING SOPHISTICATED QUERIES AND UTILIZING AN UNDERSTANDING OF DATA PRESENTATION FUNDAMENTALS. WORKS AS PART OF THE VIRGINIA DEPARTMENT OF HEALTH, OFFICE OF INFORMATION MANAGEMENT (OIM) DATA WAREHOUSE TEAM TO PROVIDE DEVELOPMENT, SYSTEM ANALYSIS, TECHNICAL SUPPORT AND PEER TROUBLESHOOTING ASSISTANCE TO HELP IMPROVE VDH DECISION MAKING, OPTIMIZE PERFORMANCE, AND ACHIEVE REPORTING REQUIREMENTS. THIS CANDIDATE WILL WORK WITH A TEAM OF ANALYSTS, DEVELOPERS, MANAGERS, AND BUSINESS RESOURCES TO BUILD HIGHLY PERFORMING SYSTEMS.CODE SAMPLES REQUIREDSPECIFIC TASK(S): DEVELOPS ETL AND DIMENSIONAL MODELS TO PULL DATA FROM MULTIPLE SOURCES INTO DATA WAREHOUSECRITICALLY EVALUATES INFORMATION GATHERED FROM MULTIPLE SOURCES AND RECONCILES POTENTIAL CONFLICTS.COMMUNICATE AND COLLABORATE WITH CUSTOMERS TO ANALYZE INFORMATION, BUSINESS PROBLEM AND AUTOMATION NEEDS.CREATE REPORTS USING THE TOOLS SPECIFIEDASSIST IN CREATING PRELIMINARY PROJECT PLAN, TEST PLAN AND TEST CASES.Dimensional modeling Required 3 Years Business and System Analysis Required 3 Years SQL development expertise using Oracle /SQL Server 2008 or higher Required 4 Years Data Analysis using advanced techniques Required 4 Years Experience with Extract, Transform, Load (ETL) systems Required 4 Years Experience in at least one report deployment solution (i.e., Tableau, Cognos, LogiXML, Crystal Reports or Reporting Services) Desired 2 Years Creating High Level Task Plan and Deliverables Desired 3 Years Must possess excellent Oral and Verbal Communication Required 10 Years Please send resume to s...@cncconsulting.com s...@cncconsulting.com * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com s...@cncconsulting.com* -- You received this message because you are subscribed to the Google Groups SAP or Oracle Financials group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
ETL Developer - In person interview - Direct Client
*ETL Developer - **In person interview - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com s...@cncconsulting.com * Job Title: ETL Developer Location: Columbus, OH Duration: 10 months Direct Client Position In person interview 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). Experience scheduling ETL processes Desired 3 Years Experience developing and modifying ETL processes with Pentaho Desired 1 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 *Please send resume to s...@cncconsulting.com s...@cncconsulting.com * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups SAP or Oracle Financials group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.