Senior GreenPlum / DataStage Engineer

Information Technology
191832 Requisition #
About this Opportunity

Enterprise Application Support (EAS) provides centralized application and infrastructure support for all critical business applications and infrastructure support.

Senior Application Support Engineer is responsible for providing technical support leadership of all the application suites within DTCC, including Global Trade Repository (GTR) application suite and all other Solutions applications. The role will be executing all aspects of the operating procedures/runbooks within a predefined shift pattern. This role is expected to work closely with the required development teams, our Enterprise Infrastructure partners and our internal business clients to resolve and escalate technical support incidents where necessary.


Business Unit: Information Technology


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. 


Department: Enterprise Infrastructure

Enterprise Infrastructure delivers infrastructure capabilities that emphasize the collaboration between development and infrastructure to meet business needs. This is done by providing technology services that are agile, timely, cost-effective, and risk appropriate.

What You'll Do


  • Support DTCC applications by providing monitoring, application, and system support for DTCC‘s production application services client facing environments.
  • Provide 24x7 support for event monitoring, incident triage and escalation.
  • Provide support to all jurisdictions on a shift basis, handling any activity for any region within the local time zone coverage.
  • Identify and implement efficiencies and improvements to standard processes and procedures such as automation through scripting, programming, etc.
  • Assist with key projects by executing task deliverables and ensuring permit-to-operate (PTO) guidelines are met.
  • Provide support for change management approval, execution for DTCC’s production application services
  • Client support team engagement to assist with application related incidents, client testing and integrations
  • Disaster recovery test planning and execution - application environment review, shutdown, start, verification, troubleshooting
  • Access administration for application access to DTCC's production application services
  • Support management of resources that are involved in maintaining the host operating system on UNIX, Vmware and Windows servers and/or software subsystems such as databases, web server software, LDAP, and security subsystems.
  • Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately

Specific Skills:

7 years of IT experience in development, testing, implementation and enterprise application support using PL/SQL, SQL for Oracle and Data warehousing.

At least 3 years of experience with GreenPlum Database in developing PostGreSQL programming with GreenPlum functions required.

Extensive experience in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Must have strong experience in UNIX/Linus Scripting for Batch systems scheduling/ processing and Autosys scheduling tool.

Working knowledge with Bitbucket Version control & repository tool.

Experience in development of ETL and warehousing techniques using DataStage 11.5 tool is a desirable plus.

Experience in BI Reporting tools such as Cognos11.0 tool and exposure in Splunk tool are added advantage to deal with application management/compliance and business analytics.

Familiarity with different programming languages such as Java & front end technologies.

Works with Infrastructure teams to stand up development, testing, and production environments.

looking for person to learn new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively.

Should be excellent team player with an ability to perform individually, good interpersonal and analytical skills.

Sound Like You?

  • Minimum of 6 years of related experience
  • Bachelor's degree preferred with Masters or equivalent experience


Who We Are

With over 40 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From our operating facilities and data centers around the world, we automate, centralize, and standardize the processing of financial transactions across the trade lifecycle, mitigate risk for thousands of institutions worldwide and protect the stability of the global financial system. We’re also leaders in the digital transformation of post-trade processing, leveraging the latest fintech innovations to meet the evolving needs of our clients to reduce costs and enhance efficiencies.

At DTCC we value our clients’ interests and partner to deliver superior results with excellence and innovation and lead with integrity. We proactively develop your potential and invest in your career. For more information, go to or connect with us on LinkedIn, Twitter, YouTube and Facebook.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

Dallas - Crestside

📁 Information Technology

Requisition #: 191717


📁 Information Technology

Requisition #: 191432

Jersey City

📁 Information Technology

Requisition #: 191195