-- I have a very urgent DIRECT CLIENT requirement for ETL Developer in Albany, NY. 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 Location: Albany, NY Duration: 12 Months 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. 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 "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 https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
