Software Engineer II

M&T Bank•Wilmington, DE

1d•Hybrid

About The Position

Develop, design, and support ETL processes. Prepare and manage the technical components of project plans. Perform unit testing of the jobs and assist with SIT (System Integration Testing) and UAT (User Acceptance Testing). Create pipelines to deploy code to higher environments. Work closely with data stewards for data mapping and implement extraction and transformation of data from various sources. Work with ETL tools and programming languages to create ETL workflows. Collaborate with other development, operations, and technology staff in overall systems development. Maintain code repositories. Document ETL processes, procedures, and specifications. Maintain the efficient operation and effectiveness of supported applications. Fine-tune production applications for performance. Support production applications and resolve production incidents from the incident queue.

Requirements

Bachelor’s degree (or foreign equivalent) in Computer Science or a related technical field plus five (5) years of experience in the job offered or as a Software Developer, Software Programmer, Computer Engineer or related occupation.
One (1) year of experience with Designing and Developing Datawarehouse Applications using Hadoop ecosystem tools including Apache Hive.
One (1) year of experience using Shell Scripting as part of the application design.
One (1) year of experience Designing and Developing Applications in Python.
One (1) year of experience using Snowflake as the backend for Datawarehouse Applications.
One (1) year of experience using ETL tool Informatica for building ETL workflows.
One (1) year of experience maintaining code repositories and creating pipelines using Git or Bitbucket.
One (1) year of experience using Spark programming language for data processing.
One (1) year of experience using a Scheduling tool including Apache Airflow or Automic to schedule jobs and workflows and monitor the daily runs of jobs and workflows.
One (1) year of experience using SQL to query data from SQL Server.

Responsibilities

Develop, design, and support ETL processes.
Prepare and manage the technical components of project plans.
Perform unit testing of the jobs and assist with SIT (System Integration Testing) and UAT (User Acceptance Testing).
Create pipelines to deploy code to higher environments.
Work closely with data stewards for data mapping and implement extraction and transformation of data from various sources.
Work with ETL tools and programming languages to create ETL workflows.
Collaborate with other development, operations, and technology staff in overall systems development.
Maintain code repositories.
Document ETL processes, procedures, and specifications.
Maintain the efficient operation and effectiveness of supported applications.
Fine-tune production applications for performance.
Support production applications and resolve production incidents from the incident queue.