Oracle Database Engineer at Softworld Inc

Job Title: Oracle Database Engineer

Job Location: Woburn MA 01801

Onsite Requirements:

• ODI
• Strong skills with data warehousing
• Service based project experience- product based experience won't translate well.

Job Description:

• We are looking for a senior resource with proven expertise in Oracle databases, SQL, and PL/SQL, particularly in the ETL processes using Oracle Data Integrator (ODI).
• The ideal candidate should have a strong aptitude for communication and a knack for translating complex business processes into logical technical solutions.
• Knowledge of Oracle Cloud Infrastructure, Oracle Analytics Server (OAS) and Python is considered advantageous.

Qualifications & Responsibilities:

• Bachelor's degree in computer science, Information Technology, or related field.
• 7+ years of experience as a Database Engineer, with a focus on Oracle databases, SQL, PL/SQL, Data Warehousing and ETL.
• Design, develop, and maintain ETL processes using Oracle Data Integrator (ODI) to ensure efficient and accurate data movement and transformation.
• Expertise in data modeling and development for OLTP, OLAP (Data Lake, Star Schema, Snowflake Schema, Data Warehouse, Data Marts and Multi-Dimensional Modeling).
• Collaborate closely with cross-functional teams to gather requirements, analyze complex business processes, and translate them into logical technical solutions.
• Optimize database performance, troubleshoot issues, and implement solutions to ensure data integrity, reliability, and scalability.

** 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply.

This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. **