SQM Lead

Quest Oracle Community; Pune District; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Northern Trust in Pune is seeking a Software Quality Engineer with 5-8 years of IT experience to ensure the performance, scalability and reliability of complex distributed applications in non-PROD environments, partnering with stakeholders in an agile setting.

You will build and maintain stable production-like non-PROD environments, ensure high-quality test data availability, and enable end-to-end testing across systems using Azure DevOps, GitHub, and CI/CD pipelines.

Qualifications

• 5 to 8 years of experience; education and experience may be combined to satisfy experience requirements.
• Strong knowledge on distributed systems, Linux or Windows platform, microservices.
• Strong knowledge of complex SQL and optimization techniques.
• Strong knowledge in database concepts for data refresh strategies (Oracle, MSSQL).
• Intermediate knowledge of scheduling tools like Control-M.
• Background in test data management, synthetic data generation.
• Good knowledge of middleware / messaging platforms: Solace, MQ, Kafka.
• Experience with Azure DevOps, GitHub, CI/CD pipelines.
• Understanding of DevOps model, ITSM, Shell scripting and JavaScript, PCF, Azure.
• Domain knowledge would be an added advantage.
• Excellent communication and presentation skills

Responsibilities

• Design, build, and maintain stable test environments.
• Replicate production configurations and dependencies.
• Define environment strategy (INT, UAT).
• Monitor environment health and resolve issues.
• Perform root cause analysis for failures.
• Define test data strategy and sourcing approaches.
• Execute test data provisioning and refresh cycles.
• Perform data validation and reconciliation using SQL.
• Ensure end-to-end data traceability.
• Support CI/CD pipelines with automated data setup.
• Ensure data privacy compliance in non-PROD environments.
• Implement data masking using Delphix.
• Define masking rules for sensitive data.
• Support audit and regulatory compliance.

Skills

Distributed systems

Linux/Windows

Microservices

SQL optimization

Test data management

Cloud environments

DevOps awareness

Middleware / Messaging

CI/CD pipelines

Communication

Tools

Azure DevOps

GitHub

Delphix

SQL tooling

Job description

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world's most successful individuals, families, corporations and institutions.

Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide.

With more than 135 years of financial experience and over 24,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.

Role Description

""

Software Quality Engineer with expertise in distributed systems with 5 -8 years of IT experience. As a Quality Engineer, he/she should ensure the performance, scalability, reliability of NT complex applications maintained in non-PROD environments , diverse technologies, and Cloud environments. The individual will work closely with various stakeholders in an agile fashion, to jointly own the solution, and strong communication and management skill to interface well with other parts of the organization.

The role is responsible for building and maintaining stable, scalable, production-like non-PROD environments, ensuring high-quality and compliant test data availability, and enabling end-to-end testing across complex systems

""

Responsibilities

Environment Build & Management

• Design, build, and maintain stable test environments
• Replicate production configurations and dependencies
• Define environment strategy (INT, UAT)
• Monitor environment health and resolve issues
• Perform root cause analysis for failures

Test Data Management & Setup

• Define test data strategy and sourcing approaches
• Execute test data provisioning and refresh cycles
• Perform data validation and reconciliation using SQL
• Ensure end-to-end data traceability
• Support CI/CD pipelines with automated data setup

Data Masking & Compliance

• Ensure data privacy compliance in non-PROD environments
• Implement data masking using Delphix
• Define masking rules for sensitive data
• Support audit and regulatory compliance

Required Experience and Skills

• 5 to 8 years of experience; education and experience may be combined to satisfy experience requirements.
• Strong knowledge on distributed systems, L inux or windows platform , microservices.
• Strong knowledge of complex SQL and optimization techniques.
• Strong knowledge in Database concept to analyze and from D ata R efresh strategy - Oracle, MSSQL .
• Intermediate knowledge of any scheduling related tools like Control - M.
• Background in test data management, synthetic data generation.
• Good Knowledge of Middleware /Messaging platforms : Solace, MQ, Kafka
• Experience with tools like Azure Dev Ops (ADO) Boards, Github , CI/CD pipeline etc.
• Understanding on DevOps model , ITSM , Shell scripting and Java script , PCF , Azure.
• D omain knowledge would be added advantage.
• Excellent communication and presentation skills

Working with Us

As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve.

Philanthropy is deeply rooted in Northern Trust's history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.

Reasonable Accommodation

Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at [e-mail] , or alternatively you can discuss your individual requirements with the recruiter you are working with.

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.