Senior ETL Developer

Uppdragsbeskrivning

Our customer is looking for a Senior ETL Developer.

Responsibilities:

• Analysis and requirements management
  • Analysis of business and technical requirements relating to the ABS transaction.
  • Creation and specification of requirements for data provision to Intertrust and LP-Corp.
  • Definition of requirements for the processing of buy-back data within the existing data warehouse landscape.
  • Coordination of technical requirements with the business departments and the project units involved.
• ETL development and data warehouse implementation
  • Independent technical design of the required data flows and data models.
  • Development and implementation of the ABS specification across all relevant data warehouse layers (IL, SL and OL layers).
  • Preparation, processing and provision of flagging data for the Leasman import.
  • Development and customisation of Informatica mappings, workflows and sessions.
  • Ensuring data quality and compliance with existing development and architecture standards.
• Interface integration
  • Technical design and implementation of an SFTP interface within the Informatica platform.
  • Implementation of automated loading processes, including error handling and monitoring.
  • Ensuring stable and audit-proof data exchange between the systems involved.
• Testing and Quality Assurance
  • Creation of technical test concepts and test cases.
  • Conducting technical tests for database objects and Informatica components in the IL, SL and OL layers.
  • Analysis, resolution and tracking of identified errors.
  • Supporting business departments with functional testing and acceptance testing.
  • Carrying out error analyses and resolving errors during the testing phase.
• Documentation and Compliance
  • Creation and maintenance of technical project documentation.
  • Documentation of source-to-target mappings, data flows and process descriptions in the wiki.
  • Assisting with the creation and maintenance of BAIT-compliant documentation.
  • Preparing and implementing necessary measures within the framework of the Internal Control System (ICS).
  • Ensuring the traceability and audit-proof nature of the implemented solutions.

Skills:

• Technical requirements
  • Several years’ experience in the development of ETL processes in an enterprise data warehouse environment.
  • Experience in implementing complex data integration processes.
  • Knowledge of ABS/asset financing processes is an advantage.
  • Experience in regulatory or audit-related projects (BAIT, ICS) is desirable.
• Technical requirements
  • Very good knowledge of Informatica PowerCenter.
  • Very good SQL skills and experience with relational databases.
  • Experience in data warehouse architectures with multi-tier data models (IL, SL, OL).
  • Experience with SFTP-based data interfaces.
  • Experience in test management and technical quality assurance.
  • Proficiency in using Confluence/Wiki and Jira.
• Deliverables
  • Business and technical specifications.
  • Informatica developments and database objects.
  • Documented source-to-target mappings.
  • Technical test concepts and test reports.
  • BAIT- and IKS-relevant documentation.
  • Implementations ready for acceptance for the ABS Bumper 2026 solution.
  • Error analyses and proof of implementation from the test phases.
• Languages
  • Proficiency in English

Start: 1 September

End: 30 April 27

Extension possible

• Uppdrag

  Senior ETL Developer

• Bolag

  Sigma Technology Embedded Solutions

• Plats

  Sverige

• Kompetensområde

  Projektledning & Management, Systemutveckling, Test och kvalitet, Verksamhetsanalys

• Språkkrav

  Swedish/English

• Startdatum

  1 st of September 2026

• Längd

  30 th of April 2027 and possibility of extension

• Publiceringsdatum

  2026-08-28

• Svar senast

  2026-09-04

• Arbetstid

  100%

• Kontaktperson

  Martin Karlsson, martin.karlsson@sigmatechnology.com, 46736870600