ETL Developer
Summary
ETL Developer (6+ years) building and maintaining data integration pipelines for a banking/financial-sector client using Oracle Data Integrator (ODI), OCI, and OIC. Day-to-day: writing/optimizing SQL and PL/SQL, connecting cloud and on-prem sources, monitoring and tuning ETL jobs, and migrating on-prem ETL to the cloud. Sites: Jersey City, NJ; Coppell, TX; Tampa, FL.
ETL Developer needs 6 years experience
ETL Developer requires:
o Bachelor's degree preferred or equivalent experience
o Coppell, TX ; Tampa, FL, Jersey City, NJ
o . Strong hands-on experience with Oracle Data Integrator (ODI) development and administration.
o . Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
o . Experience deploying and managing ETL solutions on OCI PaaS/IaaS environments.
o . Deep understanding of ETL processes, data warehousing concepts, and cloud data integration.
o . Experience in integrating on-premise and cloud-based data sources.
Banking, financial sectors
ETL Developer duties:
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