Overview
On Site
USD 60.00 - 65.00 per hour
Contract - W2
Skills
Financial Services
Jersey
RESTful
Reporting
Apptio
Microsoft SQL Server
Microsoft SSIS
Oracle Cloud
Oracle
Database
Flat File
Scripting
Data Extraction
Migration
Performance Tuning
Technical Writing
Oracle Data Integrator
SQL
PL/SQL
Data Manipulation
Query Optimization
Management
OCI
PaaS
IaaS
Extract
Transform
Load
Data Warehouse
Data Integration
Cloud Computing
Conflict Resolution
Problem Solving
Debugging
Communication
Collaboration
Teamwork
MEAN Stack
Customer Service
Training And Development
SAP BASIS
Job Details
Software Guidance & Assistance, Inc., (SGA), is searching for an Application Developer II for a CONTRACT TO HIRE assignment with one of our premier Financial Services clients in Jersey City, NJ.
Responsibilities:
We are seeking a highly skilled Oracle ETL Developer with experience in Oracle Data Integrator (ODI), OCI - Data Integrator, OIC, REST API, SQL, and PL/SQL. Our team manages tech expense allocations, reporting, and dashboarding using Apptio and Oracle tools. To optimize our technology footprint, we are migrating our IT portfolio data warehouse from on-prem (SQL Server, SSIS) to Oracle Cloud, which involves building new integrations and replicating business and data transformation logic in Oracle. The ideal candidate will assist with this migration from on-prem to cloud and provide post-launch support of this Datawarehouse.
Required Skills:
Preferred Skills:
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
Responsibilities:
We are seeking a highly skilled Oracle ETL Developer with experience in Oracle Data Integrator (ODI), OCI - Data Integrator, OIC, REST API, SQL, and PL/SQL. Our team manages tech expense allocations, reporting, and dashboarding using Apptio and Oracle tools. To optimize our technology footprint, we are migrating our IT portfolio data warehouse from on-prem (SQL Server, SSIS) to Oracle Cloud, which involves building new integrations and replicating business and data transformation logic in Oracle. The ideal candidate will assist with this migration from on-prem to cloud and provide post-launch support of this Datawarehouse.
- Design, develop, and deploy ETL processes Oracle Data Integrator (ODI) and OCI-DI.
- Implement data integration solutions using OIC, connecting diverse data sources like cloud databases, on-premises systems, REST APIs, and flat files.
- Develop and optimize SQL and PL/SQL scripts for data extraction, transformation, and loading.
- Assist with migration of on-premises ETL solutions to cloud-based platforms as needed.
- Monitor and troubleshoot ODI jobs, performance tuning of ETL processes, SQL queries, and PL/SQL procedures.
- Prepare and maintain detailed technical documentation for developed solutions.
Required Skills:
- Minimum of 6 years of related experience
- Strong hands-on experience with Oracle Data Integrator (ODI) development and administration.
- Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
- Experience deploying and managing ETL solutions on OCI PaaS/IaaS environments.
- Deep understanding of ETL processes, data warehousing concepts, and cloud data integration.
- Experience in integrating on-premise and cloud-based data sources.
- Strong problem-solving and debugging skills.
- Good communication and teamwork abilities.
Preferred Skills:
- Bachelor's degree preferred or equivalent experience
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.