ETL Developer
ETL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: DTC1JP: ETL Developer
Duration: 6 Months
Location: Jersey City NJ 07310 (Hybrid)
Client: DTCC (The Depository Trust & Clearing Corporation)
Rate: $63 Per hour on W2.
Job Description:
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.
Your Primary Responsibilities:
. 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.
Qualifications:
. Minimum of 6 years of related experience
. Bachelors degree preferred or equivalent experience
Mandatory Skills:
. 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.
Employment Type
Full-time
