Design, develop, and maintain data pipelines and workflows using Apache Airflow to ingest, transform, and load data into the Configuration Management Database (CMDB).
Develop and optimize PL/SQL queries and stored procedures for efficient data manipulation in the CMDB.
Use NoSQL databases (e.g., MongoDB) to manage large volumes of configuration data.
Integrate data from multiple sources using MuleSoft and other integration platforms.
Perform data reconciliation to ensure accuracy and consistency across systems.
Develop and implement inventory data models based on the Common Information Model (CIM) for IT asset representation.
Design and execute ETL processes to keep the CMDB updated and accurate.
Collaborate with cross-functional teams to meet business data requirements.
Troubleshoot data issues, ensuring data integrity and availability.
Document data processes, models, and configurations for knowledge sharing and team collaboration.
Required Skills:
Proven experience in data engineering, data modeling, and scripting (Python, Perl, etc.).
Strong knowledge of Service Asset and Configuration Management (SACM) principles and systems like Microfocus Asset Manager or Peregrine Asset Center (non-ITSM).
Deep understanding of the Common Information Model (CIM) standard.
Proficiency with Apache Airflow for workflow orchestration.
Experience building web frontends and backend loading mechanisms.
Familiarity with container solutions such as iKube 2.0 (preferred), Kubernetes, or similar.
Extensive PL/SQL skills for database operations.
Hands-on experience with NoSQL databases and MuleSoft or equivalent integration tools.
Strong skills in data reconciliation, data quality management, inventory data modeling, and ETL processes.
Basic Anchor Modelling knowledge.
Excellent analytical, problem-solving, and collaboration skills.
Nice to Have:
Leadership in system environment communities.
Expertise in Salesforce-MuleSoft integration development.
Experience with infrastructure inventory on global public cloud providers and hyperscalers.
RM IT - Going the Extra Mile in Contracting, Permanent Placements, and Payroll SolutionsSince 1998, RM Group has been one of Switzerland’s largest a...