ETL Developer // DIRECT CLIENT
-- I have a very urgent DIRECT CLIENT requirement for *ETL Developer * in *Atlanta, GA*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at alb...@cncconsulting.com *Job Title: ETL Developer (#51859)* *Location: Atlanta, GA* *Duration: 4 Months* *Must have Datastage experience. Local candidates preferred. State gov experience preferred. Candidates will have to complete a background check before submission.* Job Purpose: The Senior ETL (Extract, Transfer, Load) Developer is responsible for the movement of data into and out of the Enterprise Data Warehouse (EDW) which will source data from many of Georgia Tech’s institutional systems. Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data warehouse and other system integration projects. Impact and Influence: This position will interact on a consistent basis with: other ETL developers, business/functional analysts, programmer/analysts, database/data warehouse administrators and architect. This position typically will advise and counsel: EDM and OIT staff for implementation of Data Stage and other units using Data Stage in best practices related to ETL development. This position will supervise: NA Key Responsibilities: • Analyze reporting requirements to determine development methods, development templates, and to determine job scheduling. • Work in an Enterprise Data Warehouse (EDW) environment tasked to build a data warehouse using complex transformations that come from many of Georgia Tech’s systems. • Develop ETL jobs primarily in IBM Data Stage, that satisfy identified business process and data models. • Troubleshoot and help improve existing ETL jobs. • Follow set standards and best practices in ETL development. Refactor existing jobs that do not follow set standards. • Provide guidance in some Data Stage administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues in unusually long running jobs, etc. • Work with other development units in improving best practices in ETL development for Georgia Tech. • Monitor nightly loads and troubleshoot any issues that may arise. • Maintain technical support documentation. • Other related duties as assigned. EDUCATION, SPECIALIZED KNOWLEDGE AND EXPERIENCE: Degrees required for this job: Bachelor’s degree in related field, or equivalent combination of experience and education Degrees preferred: Years of experience required for this job: 6- 8 years of job related experience. At least 6 years in ETL development on any tool and at least 4 years in IBM Data Stage ETL tool. These may overlap for a total of 6 years work experience Years preferred: Certifications or licenses required for this job: Certifications or licenses preferred: SPECIALIZED SKILLS: Specialized skills required for this job: Technical Skills Required: • Full life-cycle experience on large/complex enterprise software development projects. • Hands on experience in IBM DataStage ETL Design, Development & Build. • Experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects. • Experience in developing best practices, unit testing and developer code reviews. • Understanding of Unix/Linux system, files systems, shell scripting. • Understanding of databases/ data marts/data warehouses and complex SQL and Oracle PL/SQL. Experience with databases including Oracle (11gR2), Microsoft SQL Server, MySQL. Other Skills Required: Strong written and verbal communication skills including the ability to express ideas concisely and clearly to both technical and non-technical audiences. Good problem solving and analytical skills used to resolve technical problems. Must possess a good understanding of business requirements and IT strategies. Ability to work independently, but is also a team player. Ability to lead a team of ETL developers. Specialized skills preferred: Experience in a Higher Education environment. Experience with PeopleSoft HCM and/or PeopleSoft Financials Experience with Banner. Skills Data Warehousing Advanced3-4 yrs Yes Skills IBM Infosphere DataStage ETL development and administration Expert 5-6 yrs Yes Skills Oracle Advanced 4-5 yrs Yes Skills SQL Expert 6-7 yrs Yes Very Truly, Albert Smith CNC Consulting, Inc The enterprise resource for staff augmentation 201-588-9137 P 201-541-9128 F alb...@cncconsulting.com www.cncconsulting.com -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an e
ETL Developer -Direct Client
*ETL Developer -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **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 * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com * -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. 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 * 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 * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com * -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. 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 * 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 * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com * -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. 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 * 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 * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. 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 * 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 "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps?hl=en. For more options, visit https://groups.google.com/groups/opt_out.