Senior Data Engineer – PL​/SQL & Java

Overview

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 delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

• 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.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The Development family is responsible for creating, designing, deploying, and supporting applications, programs, and software solutions. May include research, new development, prototyping, modification, reuse, re-engineering, maintenance, or any other activities related to software products used internally or externally on product platforms supported by the firm. The software development process requires in-depth subject matter expertise in existing and emerging development methodologies, tools, and programming languages.

Software Developers work closely with business partners and / or external clients in defining requirements and implementing solutions. The Software Engineering role specializes in planning, documenting technical requirements, designing, developing, and testing all software systems and applications for the firm. Works closely with architects, product managers, project management, and end-users in the development and enhancement of existing software systems and applications, proposing and recommending solutions that solve complex business problems

• Design, build, and optimize scalable, high ‑ performance data pipelines and processing workflows.
• Develop and enhance complex Oracle PL/SQL code including queries, packages, procedures, and performance tuning.
• Use Java to build or maintain data transformation services and backend processing components.
• Use Java to perform data transformation logic and build API for downstream consumption
• Interpret, analyze, and process large datasets from multiple data sources.
• Lead end ‑ to ‑ end data engineering initiatives, ensuring solutions meet performance, reliability, and scalability expectations.
• Collaborate with architects, analysts, product teams, and developers to understand requirements and deliver quality data solutions.
• Modernize existing ETL workloads into cloud ‑ ready or cloud ‑ native architectures.
• Support data quality, reconciliation, validation, and error ‑ handling processes.
• Mentor junior engineers and contribute to engineering best practices, patterns, and standards.
• Partner with cross ‑ functional teams to troubleshoot data issues and identify long ‑ term solutions

• 6-8 years of experience delivering complex technology products or platforms.
• Bachelor’s degree preferred or equivalent practical experience.

• Strong hands-on experience with Oracle PL/SQL, including advanced query writing and performance tuning.
• Proficiency in Java, especially for backend data processing and custom transformations.
• Deep understanding of data engineering concepts—pipelines, transformations, data movement, data validation, and performance optimization.
• Experience with ETL concepts and tools (Informatica acceptable)…