SQM Lead

Northern Trust
Pune, Bengaluru
Workplace: OnsiteFull timeFunction: Administration & Executive AssistanceExperience: 5-8 yearsSkills: ["Communication","Presentation","Root cause analysis"]

Build and maintain stable, scalable non-PROD test environments by replicating production configurations, defining INT/UAT strategies, and monitoring environment health. Own end-to-end testing readiness through test data strategy, provisioning/refresh cycles, SQL-based validation and traceability, and CI/CD-supported automated data setup. Ensure non-PROD data privacy compliance with masking via Delphix and support audit/regulatory requirements, with root-cause analysis for failures.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Northern Trust
Northern Trust
1 month ago

SQM Lead

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 1 hour agoStatus: Live

Job Summary

Build and maintain stable, scalable non-PROD test environments by replicating production configurations, defining INT/UAT strategies, and monitoring environment health. Own end-to-end testing readiness through test data strategy, provisioning/refresh cycles, SQL-based validation and traceability, and CI/CD-supported automated data setup. Ensure non-PROD data privacy compliance with masking via Delphix and support audit/regulatory requirements, with root-cause analysis for failures.
Location: Pune, Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Administration & Executive Assistance
Seniority: Mid level

Key Responsibilities

  • •Design, build, and maintain stable test environments and replicate production configurations and dependencies.
  • •Define environment strategy for INT and UAT; monitor environment health and resolve issues.
  • •Define test data strategy and execute test data provisioning and refresh cycles for end-to-end testing.
  • •Perform data validation and reconciliation using SQL and ensure end-to-end data traceability; support CI/CD pipelines with automated data setup.
  • •Ensure data privacy compliance in non-PROD environments using Delphix data masking and define masking rules for sensitive data; support audit and regulatory compliance.

Key Requirements

  • •5 to 8 years of experience (education and experience may be combined).
  • •Strong knowledge of distributed systems, Linux or Windows platforms, and microservices.
  • •Strong knowledge of complex SQL and optimization techniques.
  • •Strong knowledge of database concepts for Data Refresh strategy (Oracle, MSSQL).
  • •Intermediate knowledge of scheduling tools (e.g., Control-M).
Experience:5-8 years
Skills:CommunicationPresentationRoot cause analysis
Tech Stack:LinuxWindowsDistributed systemsMicroservicesSQLOracleMSSQLControl-MDelphixSolaceMQKafkaAzure DevOps (ADO)GitHubCI/CDDevOpsITSMShell scriptingJava scriptPCF

Company Brief

Northern Trust
Global financial services firm providing wealth management, asset servicing, asset management, and banking solutions to institutions, corporations, and affluent individuals, with a focus on custody, investment management, and technology-driven services.
Industry: Asset Management
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Chicago, United States
Founded: 1889
Glassdoor
Glassdoor: 3.9
WebsiteLinkedIn