ETL Developer

Project

Description:

Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.

DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer will be responsible for developing ETL primarily utilizing Microsoft & Azure technologies within industry recognized ETL standards, architecture, and best practices.

Responsibilities:

- Act as a technical expert in the designing, coding, unit testing, supporting, and debugging of data warehouse software components in all aspects of SDLC
- Apply cloud and ETL engineering skills to solve problems and design approaches
- Troubleshoot and debug ETL pipelines and creating unit tests for ETL pipelines.
- Assess query performance and actively contribute to optimizing the code
- Write technical documentation and specifications
- Support internal audit by submitting required evidence
- Create reports and dashboards in the BI portal
- Work with Development Lead, DWH Architect and QA Engineers to plan, implement and deliver best ETL strategies
- Work with business analysts to understand requirements to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements
- Communicate effectively in a collaborative, complex and high performing team environment as per Agile principles

Mandatory Skills

Description:

- Proven work experience as an ETL Developer
- SQL Server , SSIS and SSMS
- Advanced knowledge of relational databases and dimensional Data Warehouse modelling concepts
- Good understanding of physical and logical data modeling
- Very good understanding of modern SaaS / PaaS data solutions in a cost conscious approach
- Expert level of knowledge of Microsoft Data stack
- Experience in developing and deploying data oriented solutions in Cloud (Azure / Synapse Analytics / Fabric)
- Experience in designing and implementing data transformation and ETL layers using Data Factory, Notebooks

- Experience with Power

BI for report & dashboard creation. Power Query and/or DAX is an advantage.
- Experience in / understanding of Azure Data Lake Storage
- Knowledge / use of CI/CD tools and principles, preferably Azure Dev Ops or Bamboo
- Strong SQL knowledge, able to create complex SQL queries and good understanding of stored procedures, views, indexes, functions, etc.
- Good working knowledge of at least one scripting language. Python is an advantage.

- Experience with GIT repositories and working with branches. Git Hub, Azure Dev Ops or Bitbucket experience are preferable.
- Ability to troubleshoot and solve complex technical problems
- Good understanding of software development best practices

- Working experience in Agile projects; preferably using JIRA
- Experience in working in high priority projects preferably greenfield project experience
- Able to communicate complex information clearly and concisely.
- Able to work independently and also to collaborate across the organization
- Highly developed problem-solving skills with minimal supervision
- Understanding of data governance and enterprise concepts preferably in banking environment

Nice-to-Have Skills

Description:

- Microsoft Fabric
- Snowflake
- Azure Dev Test Labs, ARM templates
- Azure Pur View
- Banking / finance experience