Sr. Oracle ETL Developer

Greetings from Sligo Software Solutions, Inc. !!

This is Dasharatham 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 : 14 Months

Client : NY State - Office of Children & Family Services

Job ID: SLG - 19 - 10446

Respond by: 04/10/25 5:00 PM

Description

This 14-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). The developer will design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.

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.
• Perform writing of complex stored procedures/triggers in an Oracle database.
  
  

Mandatory Requirements

• Experience (12 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é
• Copy of Candidate Identification (i.e., Driver’s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
  
  

Thank you,

Katta Dasharatham

Recruiting Team Lead

Sligo Software Solutions Inc.

dasharatham.katta@sligosoft.com

www.sligosoft.com

Direct: (518) 818-6239

Office: (518) 444 0459 x 116

Fax : (518) 444 0457

https://www.linkedin.com/in/dasharatham/

• Due to my back-to-back calls, there are times when I might miss your calls. Email is the best way to reach me**