Technical lead Data Engineer (ETL Developer)

ERGO Technologies and Services IndiaERGO Technology & Services India (ET&S India) is the newest part of the ERGO Technology & Services Management the main outsourcing provider of IT for ERGO worldwide. It is backed up by ERGO an 18 Billion Euro Organization with a presence in 15+ countries have a charter to provide technology services to the ERGO countries in multiple countries.

Role Description:

• Create procedures and packages to meet the ETL requirements (including testing)
• Conduct performance analysis to optimize the impact on operational systems
• Contribute in master data management projects and provide feedback on data flows
• Engage in the Data Team for sharing knowledge & work in close collaboration with the architects
• Mentoring Developers and coaching junior team members
• Conducting Code reviews and enforcing coding standards
• Representing the data engineering team in broader IT discussions
• Translating business goals in technical data models

Requirements

Hard skills

• You have a higher education degree and you have at least 5 years experience as a ETL Developer
• By preference you are bilingual (NL-FR) and you have a good knowledge of English

• Profound knowledge of T-SQL scripting & querying is essantial

• Profound knowledge of the MS SQL stack (DB SSIS SSRS) on 2019 and 2022 releases, Standard Edition is essential

  Knowledge of Azure based ETL Solutions such as Azure Data Factory and/or Fabric
• Knowledge of Databricks
• Experience in other ETL concepts & technologies is an added value
• Knowledge of both batch ETL as well as streaming services (via Kafka and other)
• Experience in setting up integrations and migrating from legacy to new concepts is a must
• Profound knowledge of T-SQL scripting & querying
• Knowledge of the MS SQL stack (DB SSIS SSRS) on 2012 and 2016 releases, Standard Edition
• Experience in implementing solutions with SQL Server Integration Services (SSIS) & its ETL capabilities
• Strong experience in Data warehousing (DataVault, ...) and tools (Power BI, ...)
• Knowledgeable about data modeling, data access, and data storage techniques
• Big data (hadoop, ...), pipeline orchestration, log collection & distribution tools a plus

Must have

• At least 5 years experience as a ETL Developer
• Profound knowledge of T-SQL scripting & querying is essential
• Profound knowledge of the MS SQL stack (DB SSIS) on 2019 and 2022 releases
• Experience in setting up integrations and migrating from legacy to new concepts is a must
• Profound knowledge of T-SQL scripting & querying
• Experience in implementing solutions with SQL Server Integration Services (SSIS) & its ETL capabilities
• Knowledgeable about data modeling, data access, and data storage techniques

Good to have

• PowerBI
• Strong experience in Data warehousing (DataVault, )

Wish list

• Standard Edition is essential Knowledge of Azure based ETL Solutions such as Azure Data Factory and/or Fabric
• Knowledge of Databricks
• Knowledge of both batch ETL as well as streaming services (via Kafka and other) Big data (hadoop, ...), pipeline orchestration, log collection & distribution tools a plus