ETL Developer

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and JQuery mobile. 

Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us.

We make sure that we deliver performance driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.

Position: ETL Developer with “OSC” experience

Location: Albany, NY

Duration: 12+ Months

Only Local candidates as F2F interview is required

The New York State Office of the State Comptroller (“OSC”) intends to procure Extract/Transform/Load (ETL) developer staff augmentation services to assist with data analytics initiatives pursuant to its discretionary purchasing authority under State Finance Law § 163(6). This procurement opportunity is limited to New York State businesses certified pursuant to Article 15-A of the New York State Executive Law.

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:

o Reviewing and analyzing the existing FirstNY and new Data Analytics warehouse environments’ design architecture and communicating this information to Data Analytics Bureau staff;

o Assisting with the implementation of Data Analytics architecture design to accept structured and unstructured datasets as they are acquired through the Data Analytics Bureau;

o 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

o Assisting in the design and development of OBIEE dashboards and reporting as defined through user story and use case development from business analysis teams.

o 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 co mplex 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:

o Strong presentation and verbal skills demonstrating the ability to communicate complex technical information to a non-technical audience,

o Strong written skills with the ability to document technical designs, and

o Strong instructional skills for mentoring and knowledge transfer through hands-on training.

Regards,

Vishal Rana

Talent & Client Acquisition Specialist

Phone: 510 254 3300 Ext 178 |