ETL Developer -Direct Client
*ETL Developer -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: ETL Developer Location: Albany, NY Duration: 12 Months Direct Client Position Client: State of NY (OSC) Note: Need 2 references Background OSC has commenced a Data Analytics Initiative to support the Agency’s audit planning and analysis activities; increase fraud, waste and abuse recoveries using new protocols established under the Enterprise Fraud Prevention Act (Chapter 566); expand Open Book New York web portal and related transparency efforts; and increase operational efficiencies through the use of performance analysis. The initial step in this project is the development of an Analytics Data Warehouse based on a formally architected framework to build an environment for OSC examiners, auditors and analytics staff to fully realize the benefits of business intelligence and data analytics tools. The ETL developer (the “Consultant”) will assist OSC with these efforts. Scope of Work The Consultant shall: •Working with the Data Analytics Bureau and the Division of the Chief Information Officer (“CIO”) staff, assist with the build-out of the current OSC environment for both infrastructure and tools as they relate to Data Analytics and the necessary supporting technologies, such as data warehousing, business intelligence, statistical analysis, and data exchanges with external agencies/entities. Tasks will include, but are not limited to: ?Reviewing and analyzing the existing FirstNY and new Data Analytics warehouse environments’ design architecture and communicating this information to Data Analytics Bureau staff; ?Assisting with the implementation of Data Analytics architecture design to accept structured and unstructured datasets as they are acquired through the Data Analytics Bureau; ?Assisting with the implementation of Oracle Business Intelligence Enterprise Edition (“OBIEE”) RPD environment as defined through user story and use case development from business analysis teams; and ?Assisting in the design and development of OBIEE dashboards and reporting as defined through user story and use case development from business analysis teams. ?Providing ongoing knowledge transfer to State resources on all work completed above. •Assist CIO with the extraction, transformation and loading of newly identified/acquired data into the FirstNY environment. •Work with CIO and OSC business customers to define and build OBIEE reports/queries. •Assist CIO staff with maintenance and troubleshooting of FirstNY warehouse environment, OBIEE tool, and other tools as needed. Minimum Qualifications The Consultant must possess the following minimum qualifications: •A Bachelor’s Degree (4-year degree); *•Five years of experience developing and maintaining a data interchange system interfacing with a custom financial system (e.g., PeopleSoft or Oracle Applications);* *•Five years of experience working with an ETL tool such as Oracle Warehouse Builder or Oracle Data Integrator; * *•Five years of experience working with Oracle Business Intelligence (i.e., OBIEE, Discoverer, Oracle Reports); * •Five years of experience with Oracle SQL; •Five years of experience with technical user documentation for knowledge transfers; and •Five years of experience with standardizing and streamlining complex SQLs to enhance performance. Preferred Qualifications OSC will give preference to candidates with the following qualifications: •Strong communication skills working with both technical and non-technical people, including: ?Strong presentation and verbal skills demonstrating the ability to communicate complex technical information to a non-technical audience, ?Strong written skills with the ability to document technical designs, and ?Strong instructional skills for mentoring and knowledge transfer through hands-on training. *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 ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at https://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
ETL Developer -Direct Client
*ETL Developer -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: ETL Developer Location: Raleigh, NC Duration: 7 months Direct Location Position Client: State of NC Rate: $50-55/hr on C2C *Local candidates preferred. State gov exp preferred* ETL Developer to work closely with Project Manager and Data Architect to define, document, develop and test data transformation solutions for the Data Management and Governance project. This individual will develop Extract, Transform and Load (ETL) packages using Microsoft SQL Server Integration Services. This individual will be experienced in ETL concepts, development techniques and best practices. Sample Role Types: Developer, Programmer, Systems/Software Engineer, Web Developer, Application Developer Expected Skills: Able to work without assistance; can provide leadership to others; able to manage highly complex work efforts; may have advanced education; may have extensive industry experience. Description (including, but not limited to): 1. Development and enhancement of applications based on established design specifications 2. Analysis, design, coding, component/assembly testing of all application code owned by the Application Team 3. Implementing configuration changes to software applications to meet both functional and technical requirements 4. Writing application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions, maintenance (including production support) 5. Unit testing applications and developing system and user documentation Proven experience in design, development and testing of ETL packages using SSIS, TSQL and Stored Procedures Required7Years Experience in ETL integrating data from heterogeneous systems Required7Years Experience creating complex ETL tha utilizes containers, tasks, constraints, variables, and parameters to include performance tuning packages Required7Years Master Data Management experience in Metadata, models, data stewardship and governance, enterprise canonical data models and message schema Required5Years Experience performing code reviews, analyzing executive plans, and creating/executing test plans Required5Years Experience collaborating with project team members and complete tasks with minimal supervision Required5Years Exhibit strong communications and interpersonal skills Required5Years Clear understanding and experience with Microsoft Platforms to include both desktop and server including SSRS, SSIS and DQS Highly desired Knowledge of data quality services, physical database administration with SQL Server Highly desired *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 ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at https://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
ETL Developer -Direct Client
*ETL Developer -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: ETL Developer Location: Albany, NY Duration: 12 Months Direct Client Position Note: Need 2 references Client: NYS OSC Background FirstNY (“FNY”), a unit within OSC’s Division of the Chief Information Officer (CIO), is responsible for collecting data from numerous source systems, transforming the data into a usable format, maintaining the data’s accuracy and integrity, and securely disseminating this information to data consumers. These consumers are comprised of OSC employees and the general public. The public accesses this data through Freedom of Information Law (FOIL) requests that are fulfilled via FNY and through Open Book New York (OBNY), the Comptroller’s transparency website. Source systems include the Statewide Financial System (SFS), PAYServ (NYS payroll system), the Local Government and State Accountability subsystem, and the Public Authorities Reporting System. Data consumer demands on FNY have increased over the last several years. Additionally, OSC is undergoing a number of architectural and technological changes that are resource intensive. These include upgrading Oracle Business Intelligence Tools to Oracle Business Intelligence Suite Enterprise Edition (OBIEE) and re-architecting the FNY security model. While we are hiring and training replacements, FNY requires an ETL Developer to augment remaining staff. Scope of Services Under the direction of the Manager of FirstNY, the ETL Developer will: 1.Collaborate with coworkers, system users, business analysts and other CIO teams to gather requirements for system changes and enhancements; 2.Perform analysis necessary to understand the requirements for system changes and enhancements and any factors related to fulfilling these requirements; 3.Design solutions to satisfy requirements for system changes and enhancements; 4.Identify, analyze and resolve production issues; 5.Develop, remediate, enhance and refactor program code and Oracle Warehouse Builder objects to implement design solutions and to enhance code readability, efficiency, and maintainability; 6.Design test plans to confirm that the requirements of system changes and enhancements are being met. Regression, unit, and integration testing should be included in the design, as required; 7.Create and maintain documentation, as needed. Documentation will be required for: ?Program units and objects, ?Processes, ?Environment setup and configuration, ?Solutions identified to resolve problems, ?Test plans, ?Business requirements, and ?Design documents; 8.Report to the Manager of FirstNY on the status of tasks and any issues encountered in applications; 9.Under the direction of the Manager of FirstNY and working with the CIO Database Administration team, develop, implement, test and maintain a new data warehouse security model, conforming to the FirstNY security guide and the FirstNY technical reference manual; 10.Provide technical guidance, mentoring, knowledge transfer, and support to other programmers; and 11.Other related duties as identified by the Manager of FirstNY. Minimum Qualifications The Proposer’s candidate(s) must have a minimum of: 1.Five years of experience developing and maintaining a data interchange system interfacing with a *custom off-the-shelf financial system, such as PeopleSoft or Oracle Applications;* 2.Five years of experience working with *Oracle Security*, including users, roles, object and system privileges, application contexts, virtual private database and associated policies; 3.One year of experience working with an *ETL tool such as Oracle Warehouse Builder or Oracle Data Integrator;* 4.Five years of experience working with *Oracle Business Intelligence (OBIEE, Discoverer, Oracle Reports).* *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 ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
BI ETL Developer - Direct Client
*BI ETL Developer - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com s...@cncconsulting.com * Job title: BI ETL Developer Location: Columbia, SC Duration: 12 Months Direct Client Position SCOPE OF THE PROJECT: ONGOING PROJECT TO DELIVER AN END TO END BUSINESS INTELLIGENCE SOLUTIONS CONTAINING DASHBOARDS AND REPORTS. DAILY DUTIES / RESPONSIBILITIES: Candidate will be responsible for creating, designing and developing the process to extract and transform data from OLTP data source and load aggregated data into OLAP environment. The ETL process should utilize the Microsoft stack of BI tools (SQL Server, SSIS, SSAS, SSRS), the candidate will be responsible to: • Design and implement ETL processes for data transactions related to Enterprise Data Warehouse and other data structures to support our Business Intelligence operations. • Analyze requirements and existing resources to create efficient database and ETL designs to support system to system data integration. • Work with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activities. REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): Technical Skills • ETL Process and Development o Slowly Changing Dimensions (SDC) Types 1,2, and 3. SDC Type 1 - Over write data changes SDC Type 2 - Add a row for data changes SDC Type 3 - Add a column for data changes o Staging and Aggregating Data Methodologies o Error and Data anomaly handling • MDX Queries • Report and Dashboard creation • KPIs. Tool-Set Skills • SSAS skills • SSIS skills • SSRS skills • TSQL skills • SQL Server (Stored Procedures, Jobs, Performance Tuning) CANDIDATE MUST BE ABLE TO COMMUNICATE CLEARLY WITH THE DEVELOPMENT TEAM, PROJECT STAFF, AND THE USER COMMUNITY. PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE): INTIMATE KNOWLEDGE OF CAPSS AND LCMS DATABASE DESIGN. Database Platforms SQL Server Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Analysis Services ( SSAS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Integration Services (SSIS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Reporting Services (SSRS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Tuning Yes 1 Expert Currently Using 2 - 4 Years Miscellaneous Dashboards and Reports Yes 1 Miscellaneous ETL Process and Development Yes 1 Miscellaneous KPI's - Key Performance Indicators Yes 1 Miscellaneous Multidimensional Expressions (MDX) queries Yes 1 Miscellaneous Slowly Changing Dimensions (SDC) Yes 1 Specialties OLAP Yes 1 Expert Currently Using 2 - 4 Years Specialties Reporting/OLAP/DW Yes *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 ABAP group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.
ETL Developer - Direct Client
*ETL Developer - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com s...@cncconsulting.com * Job Title: ETL Developer Location: Des Moines, IA Duration: 12 Months Direct Client Position ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems. Proficient in development of SQL Server Integration Services (SSIS) packages. Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL. Experience extracting data from a large variety of sources, tranforming and loading to a SQL data warehouse Evaluate and address data quality issues Developing error checking and resolution routines Experience in interacting with customers regarding application requirements. Strong business writing and interpersonal skills necessary for customer contact Skill Required / Desired Amount of Experience Expertise Rating Develop, modify and optimize SSIS packages Required 5 Years SQL 2005 Required 5 Years SQL 2008 Required 3 Years Experience building SSIS packages using built-in SSIS components Required 5 Years Experience writing complex T-SQL Required 5 Years Experience analyzing, profiling, manipulating data from a large variety of sources Required 5 Years Experience loading data into a SQL Data Warehouse Required 5 Years Troubleshoot abstract data, profile, analyze and optimize data Required 5 Years Develop error checking and resolution routines Required 5 Years Data modeling experience Required 5 Years Analyze and optimize table design Required 5 Yea *Please send resume to 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 ABAP group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap?hl=en. For more options, visit https://groups.google.com/groups/opt_out.