ETL Developer (Enterprise Datawarehouse)

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

Skills

Nice to have

Skills Required

Power Bi, Devops Tools, Etl Development, Data Visualization, Sql