Sr. Lead, Infra Cloud - Datastage

About Northern Trust:

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

This criteria targets a hybrid Senior DataStage Engineer/Platform Administrator. It emphasizes deep ETL knowledge, Information Server platform architecture, network load balancing, database operations (dsodb/xmeta), user/project administration, and extensive scripting and automation.

1. Core Platform & Architecture

• Platform Buildout & Installation: Proven experience architecting, installing, configuring, and upgrading IBM InfoSphere DataStage (v11.x+) environments.

• Network Load Balancing: Deep knowledge of network load balancing and clustering strategies to ensure high availability, horizontal scaling, and failover across DataStage engine tiers and Websphere clustered environments.

• Metadata & Repository Knowledge: Advanced SQL querying skills targeted at the Operations Database (dsodb) and Metadata Repository (xmeta DB) for monitoring performance, auditing jobs, and identify stages being used.
• Exposure to AI tools/usage in day-to-day work
• Demonstrates continuous learning and adoption of new technologies

2. DataStage Administration & Security

• User Roles & Authorization: Expertise in configuring DataStage user roles, permissions, and group policies using the WebSphere/Information Server Administration Console.

• Project Administration: Ability to create, manage, and configure DataStage projects, and handle DataStage server security.

3. Scripting, Automation & Programming

• UNIX / Linux and python Shell Scripting: High proficiency in Bash and python scripting for automation and performing server maintenance.
• Java Knowledge: Familiarity with Java for building custom user exit routine.

4. Advanced DataStage Knowledge

• ETL Pipeline Design: Extensive experience designing parallel jobs using complex stages (Transformer, Aggregator, Join, Lookup, etc.).
• Performance Tuning: Solid track record in performance tuning bottlenecks, handling large volume data sets, and partitioning strategies within parallel jobs.
• Job Orchestration: Expertise in designing parameter-driven, restartable, and auditable ETL workflows.
• Strong knowledge of infrastructure tools like Control-M, GitHub, Dynatrace, firewall, and load balancing

Working with Us:

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.

About Our Pune Office

The Northern Trust Pune office, established in 2016, is now home to over 3,000 employees. The office handles various functions, including Operations for Asset Servicing and Wealth Management, as well as delivering critical technology solutions that support business operations across the globe.

Our Pune team takes our commitment to service to heart. In 2024, they volunteered more than 10,000+ hours into the communities where they live and work. Learn more.