ETL Developer

Company: Valley National Bank
Location: Wayne
Posted on: June 25, 2022

Job Description:

Job DescriptionAs an ETL Developer in Valley Bank's Enterprise Data, Analytics and Governance unit you will be responsible for designing, building, maintaining, supporting and updating current and newly developed data solutions including ETL interfaces, Data Quality initiatives and data lake implementations.The newly developed ETL framework consolidates data from multiple sources at different frequencies into a centralized operational data store (ODS) for redistribution to downstream systems. This position will be a key contributor to furthering the design and development of the ETL framework and the ODS.Responsibilities include, but are not limited to:Develop and support ETL pipelines.Develop job scheduling, monitoring and notifications processes.Develop data models based on industry and bank standards.Develop and optimize database objects such as tables, views, indexes, partitions and stored procedures.Develop and maintain metadata, data catalog, documentation, and data governance.Help business stakeholders troubleshoot.Optimize SQL and ETL solutions to solve reporting and analytics needs.Work with business stakeholders and other technology teams to gather and document requirements for data distribution and consumption.RequirementsRequired Skills: Experience in Azure Data Factory development.Experience with building ADF Pipelines and Data Flows.Strong Experience with Data Warehousing methodologies and concepts Knowledge in Azure's ETL service for data integration and simple data transformation.Hands on experience in Python and Databricks.Good understanding and experience working on Delta Lake using Apache Delta in Azure Databricks.Experienced working on performance tuning and optimizing long running jobs.Exposure to DEVOPs.Should be proficient in writing advanced / complex SQL statements.Excellent oral and written communication skills.Strong ownership mentality with a focus on root cause analysis and issue resolution.Ability to work with business teams to identify data requirements and prevalent issues and work through to resolution.Ability to collaborate in a cross-functional team environment.Ability to quickly piece together disparate pieces of information to form a broader picture.Ability to use data todetect bugs, surprises, and other important business and data issues.Excellent communications skills in working with business stakeholders.Self-motivated and a team-player.Technical Skills (Required): ETL expertise with Azure Data Factory.Proficient hands-on experience with Python and DataBricks.Experience writing and maintaining complex queries and stored procedures.Experience with job scheduling tools like CONTROL-M or AutoSys.Experience analyzing queries or SQL stored procedures.Required Experience: Bachelor's Degree and a minimum of 5 years' experience developing within financial services, preferably Retail Banking space.Technical Skills preferred:Azure DEVOPsBig Data and NoSQL experience with technologies such as Cloudera, Snowflake or Azure SynapseExperience with C# or Java

Keywords: Valley National Bank, Wayne , ETL Developer, IT / Software / Systems , Wayne, New Jersey