Job Description

Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve. The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team provides high-quality information through activities including development of essential infrastructure capabilities, meeting client needs, and implementing data standards and governance. Pay and Benefits: Competitive compensation, including base pay and annual incentive Comprehensive health and life insurance and well-being benefits, based on location Pension / Retirement benefits Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being Flexible/hybrid work model: 3 days onsite (Tuesdays, Wednesdays, and a third day unique to each team or employee) and 2 days remote The Impact you will have in this role: We are seeking a highly skilled individual 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. We are migrating our IT portfolio data warehouse from on-premises (SQL Server, SSIS) to Oracle Cloud, which involves building new integrations and replicating business and data transformation logic. The candidate will assist with this migration and provide post-launch support of the data warehouse. Primary Responsibilities: Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI Implement data integration solutions with 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 platforms Monitor and troubleshoot ODI jobs; perform performance tuning of ETL processes, SQL queries, and PL/SQL procedures Maintain detailed technical documentation for developed solutions Qualifications: 6-8 years of related experience Bachelor's degree preferred or equivalent experience Skills for success: Hands-on experience with Oracle Data Integrator (ODI) development and administration Proficiency in SQL and PL/SQL for complex data manipulation Experience deploying and managing ETL solutions on OCI PaaS/IaaS environments Deep understanding of ETL processes, data warehousing, and cloud data integration Experience integrating on-premise and cloud data sources Strong problem-solving and debugging skills Good communication and teamwork skills Note: Salary ranges are indicative; actual salary depends on experience, skills, location, and other factors. We are an equal opportunity employer committed to diversity and inclusion. We provide reasonable accommodations for individuals with disabilities upon request. #J-18808-Ljbffr DTCC

Job Tags

Similar Jobs