Data Engineer - CMDB (m/f/d)
Your tasks:
- Design, develop, and maintain data pipelines and workflows using Apache Airflow for efficient data ingestion, transformation, and loading into the CMDB
- Develop and optimize PL/SQL queries and stored procedures for data manipulation and retrieval within the CMDB environment
- Utilize NoSQL databases for handling and processing large volumes of configuration data
- Integrate data from various sources into the CMDB using MuleSoft and other integration platforms
- Conduct data reconciliation activities to ensure data accuracy and consistency across multiple systems and sources
- Develop and implement inventory data models based on the Common Information Model (CIM) to accurately represent IT assets and their relationships
- Design and implement Extract, Transform, and Load (ETL) processes to populate and update the CMDB with accurate and up-to-date information
- Collaborate with cross-functional teams to understand data requirements and ensure the CMDB meets business needs
- Troubleshoot and resolve data-related issues, ensuring data integrity and availability
- Document data processes, data models, and configurations to maintain knowledge and facilitate collaboration
Your profile:
- Proven experience in data engineering and data modeling
- Scripting languages such as Python, Perl and Others
- Strong understanding of Service Asset and Configuration Management (SACM) principles and best practices using Systems such as Microfocus Asset Manager, Peregrine Asset Center or similar (not the ITSM part)
- In-depth knowledge of the Common Information Model (CIM) from DMTF.org.
- Proficiency in Apache Airflow for workflow orchestration and automation
- Knowledge of Container Solutions such as iKube 2.0 (preferred), Kubernetes or others
- Extensive experience with PL/SQL for database operations and data manipulation
- Experience working with NoSQL databases (e.g., MongoDB)
- Hands-on experience with MuleSoft or other integration platforms
- Strong data reconciliation and data quality management skills
- Expertise in inventory data modeling and implementation
- Solid understanding of Extract, Transform, and Load (ETL) processes using different Tooling
- Basic Anchor Modelling Skills
- Excellent problem-solving and analytical skills and strong collaboration abilities
- Fluency in English is mandatory, knowledge of German is an advantage
Apply for this job
Does this job fit your talents and seem right for you? Don't hesitate to apply online now.