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
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
?Providing ongoing knowledge transfer to State resources on all work
•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
•Assist CIO staff with maintenance and troubleshooting of FirstNY warehouse
environment, OBIEE tool, and other tools as needed.
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
•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
•Five years of experience with standardizing and streamlining complex SQLs
to enhance performance.
OSC will give preference to candidates with the following qualifications:
•Strong communication skills working with both technical and non-technical
?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
CNC Consulting, Inc
The enterprise resource for staff augmentation
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 post to this group, send email to firstname.lastname@example.org.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.