Analyze source-to-target requirements, data mappings, transformation logic, filters, joins, reconciliation rules, and downstream extract requirements. The existing UCL process requires integration of incoming datasets into the UCL table structure/unified layer and subsequent creation of downstream extracts.
Partner directly with downstream consumers to understand data requirements, required fields, filters, frequency, timing, validation criteria, and delivery expectations, reducing unnecessary handoffs between development teams.
Investigate and resolve data-quality, transformation, reconciliation, and SQL defects, determining whether problems originate in source data, business logic, integration logic, or downstream processing.
Troubleshoot Oracle ADW performance, including long-running SQL, execution plans, CPU/I/O contention, parallel execution, temporary-space utilization, and other database bottlenecks.
Design solutions capable of supporting increasing data volume, processing frequency, batch-runtime, and SLA requirements, including the movement from monthly toward more frequent/daily processing.
Support integration between UCL and technologies/platforms such as Oracle DIS, Oracle DFCS, Snowflake, Workiva, Axiom, Alteryx, OCI, and other enterprise data sources/consumers as required by the application architecture.
Participate in development, unit testing, SIT, UAT/CERT, release, deployment, and production validation, ensuring changes can be promoted safely through DEV, TEST/SIT, CERT/UAT, PREPROD, and PROD.
Diagnose production and lower-environment issues involving SQL logic, data discrepancies, interfaces, batch processing, performance, configuration, and data dependencies, and work with appropriate teams through resolution. UCL/FDI delivery history shows active developer involvement in defect remediation, testing, SIT/review transitions, and release readiness.
Provide technical guidance and code/design review for other developers and help identify inefficient, incorrect, or unsustainable implementation approaches before they reach higher environments.
Development & SDLC Responsibilities
The role is not just an SQL developer. Developers operate within a controlled enterprise SDLC:
Create and maintain Jira Stories/Tasks for development work and ensure work is associated with the appropriate Jira Feature.
Participate in refinement and provide technical analysis and estimates before development begins.
Maintain traceability between requirements, development, testing, architecture, and deployments. Feature IDs must be represented in the Solution Architecture Document, and development changes must remain traceable through the promotion lifecycle.
Participate in technical and architecture reviews and identify assumptions, dependencies, risks, constraints, and design issues early enough to prevent downstream rework.
Keep Jira work current as code/configuration progresses through development → testing → review → deployment.
Support documentation necessary to promote application objects/configurations/code through controlled environments.
Understand and adhere to the Company’s risk and regulatory standards, policies and controls in accordance with the Company’s Risk Appetite. Identify risk-related issues needing escalation to management.
Promote an environment that supports a culture of belonging and reflects the M&T Bank brand.
Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
Complete other related duties as assigned.
Scope of Technical Responsibilities
Strong / hands-on
Oracle SQL
PL/SQL
Oracle database development
Oracle Autonomous Data Warehouse (ADW)
Complex SQL optimization and performance tuning
ETL/ELT development
Data integration and transformation
Source-to-target mapping
Data reconciliation and validation
Large-volume/batch data processing
Relational database concepts and dimensional/data-model concepts
Working knowledge / desirable
Oracle Cloud Infrastructure (OCI)
Oracle DIS / enterprise data-movement technologies
Snowflake
REST APIs / Oracle REST Data Services (ORDS)
Workiva/Wdata integrations
Axiom
Enterprise schedulers / batch processing
Jira
Git / source control
CI/CD and automated deployment practices
Education and Experience Required
Associate’s degree and a minimum of 5 years' solutions development and/or relevant enterprise technology experience or a Bachelor's degree and minimum of 3 years' solutions development and/or relevant enterprise technology experience or in lieu of a degree, a combined minimum of 7 years' education and/or relevant work experience, including a minimum of 3 years’ solutions development and/or relevant enterprise technology experience
Advanced proficiency in a minimum of one relevant platform
Education and Experience Preferred
Advanced analytical skills specific to solutions development
Experience working in a team environment
Ability to work autonomously
Ability to multitask on complex projects
Strong organizational and time management skills
Proficient verbal and written communication skills
Experience working in an agile framework to meet business objectives
M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $97,100.00 - $161,800.00 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.
Location
Buffalo, New York, United States of America
