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 SDLCApply cloud and ETL engineering skills to solve problems and design approachesTroubleshoot and debug ETL pipelines and creating unit tests for ETL pipelines.Assess query performance and actively contribute to optimizing the codeWrite technical documentation and specificationsSupport internal audit by submitting required evidenceCreate reports and dashboards in the BI portalWork with Development Lead, DWH Architect and QA Engineers to plan, implement and deliver best ETL strategiesWork 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 requirementsCommunicate effectively in a collaborative, complex and high performing team environment as per Agile principlesMandatory Skills Description:Proven work experience as an ETL DeveloperSQL Server , SSIS and SSMSAdvanced knowledge of relational databases and dimensional Data Warehouse modelling conceptsGood understanding of physical and logical data modelingVery good understanding of modern SaaS / PaaS data solutions in a cost conscious approachExpert level of knowledge of Microsoft Data stackExperience 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, NotebooksExperience with PowerBI for report & dashboard creation. PowerQuery and/or DAX is an advantage.Experience in / understanding of Azure Data Lake StorageKnowledge / use of CI/CD tools and principles, preferably Azure DevOps or BambooStrong 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. GitHub, Azure DevOps or Bitbucket experience are preferable.Ability to troubleshoot and solve complex technical problemsGood understanding of software development best practicesWorking experience in Agile projects; preferably using JIRAExperience in working in high priority projects preferably greenfield project experienceAble to communicate complex information clearly and concisely.Able to work independently and also to collaborate across the organizationHighly developed problem-solving skills with minimal supervisionUnderstanding of data governance and enterprise concepts preferably in banking environmentNice-to-Have Skills Description:Microsoft FabricSnowflakeAzure DevTest Labs, ARM templatesAzure PurViewBanking / finance experience