DW ETL Developer - Rensselaer, NY - 24 Months- #

DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 Contract Candidate willing to work on our W2 payroll will be considered most. Candidates eligible to work at USA with valid visa should apply. Third Party Vendors Please do not submit your candidates. Title: DW ETL Developer - Rensselaer, NY - 24 Months-# K18511/240745 Duration: 24 Months A Data Warehouse/Business Intelligence Developer resource is needed for the OCFS Data Warehouse/CONNECTIONS Reporting Module. The DW is sourced from the agency’s major child welfare case management related systems: CONNECTIONS, CCRS, and WMS. The Data Warehouse effort consists of multiple sub-projects. The efforts over the next 18 month period will include priorities including: ODS Support; ACS Support; management of Federal data transfers; load monitoring; AFCARS support; data warehouse and data moat purge; JJ mart for AFCARS; AFCARS FTP receive files; CONNECTIONS Quarterly Build changes; Infrastructure upgrades and enhancements (Cognos and Oracle upgrades); and more. The OCFS Data Warehouse is a long term, ongoing effort to meet the data sharing and reporting needs of OCFS, the federal government, and local districts and voluntary agencies. The first deliverables were deployed in 2000, and the warehouse continues to grow in terms of data volume, functionality, and customers on a continual basis, with heightening reliance on the availability of up to date child welfare data for local operational needs. The DW effort consists of many sub-projects, each with its own schedule and deliverables. Approximately 10 sub-projects are currently in progress, with another 50 or so in the queue. This request is for a Oracle Data Warehouse/Business Intelligence Developer and is required to design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture in support of these Data Warehouse projects. In addition, this resource will be responsible for managing the Data Warehouse daily processing operations (Operational Data Store) and job schedules. If this resource is not procured, the Data Warehouse project will be left with insufficient Oracle Developers to address the workload over the next 24 months, leaving CONNECTIONS and other state and federal reporting needs unmet. Duties include but are not limited to: Work in coordination with a team of developers to expand the current Data Warehouse. Work with Business Analyst & customers on analysis and logical design for mappings and ETL. Perform unit testing and correct all identified bugs. Perform complex PL/SQL coding in a Data Warehouse environment. Assist with responding to Operational Data Store data requests. The individual in this position will work under the direction of a Technical Lead & Project Manager. Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL. Candidates should have at least 60 Months experience, and below should apply Experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes. Experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting. Experience in an Oracle Data Warehouse as a developer performing development work. Experience using PL/SQL. Experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques. Problem solving skills and ability to think and resolve technical issues under pressure. Bachelor’s Degree. Proof of Education for all candidates are to be submitted with all responses. Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects. 3 references are must with the resume. Please note that our client does allow Skype/remote interviews. However they reserve the right to require an in‑person interview. #J-18808-Ljbffr