Greetings from
Sligo Software Solutions, Inc. !!
This is
Prakashini from SLIGO. We have an urgent requirement for
Sr. Oracle ETL Developer position with our client.
Title : Sr. Oracle ETL Developer
Location : Albany, New York
Duration : 24 Months
Client : NY State - Office of Children and Family Services (OCFS)
Job ID: SLG - 19 - 9375
Respond by: 04/11/24 5:00 PM
Description
This 24-month position for a Systems Developer with experience working on a Oracle Data Warehouse/Business Intelligence team is needed for the data quality and data collection requirements for state and federal reporting on the Comprehensive Child Welfare Information System (CCWIS).
Duties
- 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.
- Respond to CCWIS 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 OWB and ODI.
Mandatory Requirements
- Experience (10+ Years)
- Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
Requirements
- This is an 100% Onsite
- 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
- 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
- 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL
- 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
- 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
- 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
- 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols
- 84 months experience in build database schemas, tables, views, indexes, and stored procedures
- Bachelor’s Degree
- Résumé
- Please submit copy of Degree
EMAIL- prakashini.nakka@sligosoft.com
Direct: (518) 800-9030
LinkedIn - Prakashini Nakka (PJ) | LinkedIn