DTCC is seeking to migrate its IT portfolio data warehouse from on-prem to Oracle Cloud, which involves building new integrations and replicating business and data transformation logic in Oracle.
Requirements
- 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.
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.
Other
- Minimum of 6-8 years of related experience.
- Bachelor's degree preferred or equivalent experience.
- Good communication and teamwork abilities.
- Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
- DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote
