Senior Data Platform Engineer - Oracle ADW & ETL Specialist

M&T Bank Corporation; Buffalo (NY); Hybrid; USD 97,000 - 162,000; Full time

Job summary

M&T Bank Corporation is seeking a Senior Solutions Developer to design, develop, test, and support data integration on the UCL Data Platform. The role emphasizes Oracle ADW, SQL/PLSQL, and ETL/ELT pipelines, with collaboration across Finance, Technology, and vendor teams.

Responsibilities include optimizing complex SQL, integrating diverse data sources, and ensuring reliable, auditable data flows with controlled release processes. Hybrid work setup in Buffalo, NY.

Qualifications

• Experience designing and implementing SQL/PL/SQL solutions with Oracle ADW.
• Proven ability to develop and optimize ETL/ELT pipelines and data movements.
• Strong collaboration with finance/tech teams and vendors within regulated environments.

Responsibilities

• Design, develop, test, and maintain ADW-based data processing solutions.
• Build and support ETL/ELT pipelines between enterprise sources and ADW.
• Analyze mappings, transformations, and reconciliation rules for downstream extracts.
• Troubleshoot data-quality, performance, and SQL defects across environments.
• Collaborate in SDLC activities, including deployment and validation.

Skills

Oracle SQL

PL/SQL

Oracle ADW

ETL/ELT

Data integration

Data reconciliation

SQL performance tuning

Snowflake

OCI

ORDS

Jira

Git

CI/CD

Education

Associate’s degree + 5+ years experience

Bachelor’s degree + 3+ years experience

Tools

Jira

Git

CI/CD tools

ORDS

Snowflake

OCI

Oracle DIS

Job description

M&T Bank Corporation is seeking a Senior Solutions Developer to design, develop, test, and support data integration on the UCL Data Platform. The role emphasizes Oracle ADW, SQL/PLSQL, and ETL/ELT pipelines, with collaboration across Finance, Technology, and vendor teams.

Responsibilities include optimizing complex SQL, integrating diverse data sources, and ensuring reliable, auditable data flows with controlled release processes. Hybrid work setup in Buffalo, NY.