Sr. Oracle ETL Developer

Prohires
Rensselaer, NY
25 Jan 2025

Vacancy expired!

Role: Sr. Oracle ETL Developer

Location: Rensselaer, New York

Duration: Long term

DescriptionThis 24-month position for a Systems Developer with experience working on an Oracle Data Warehouse/Business Intelligence team is needed to work on the juvenile justice component of the OCFS Data Warehouse.DutiesWork in coordination with a team of developers to expand the current Data Warehouse.Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.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.Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancementsPerform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODIThe individual in this position will work under the direction of a Technical Lead & Project Manager.Mandatory RequirementsExperience (8+ Years)Develops and implements applications and programs for the backend processing systems used in businesses and organizations.RequirementsThis is an 100% Onsite7+ experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.7+ experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment7+ experience working in an Oracle Data Warehouse performing development work using PL/SQL7+ experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.7+ experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)7+ 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).7+ experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols7+ experience in build database schemas, tables, views, indexes, and stored proceduresBachelor’s DegreeRésuméPlease submit copy of Degree

Thanks & Regards,

SR IT Recruiter

Aravind Kumar

Email:

USA : lt;/strong>

;/strong>
  • ID: #48797882
  • State: New York Rensselaer 12144 Rensselaer USA
  • City: Rensselaer
  • Salary: $60 - $65
  • Job type: Contract
  • Showed: 2023-01-25
  • Deadline: 2023-03-24
  • Category: Et cetera