Sarra Ben Osman

Creation and maintenance of Talend jobs for bank debt recovery.

• Analysis of needs and technical specifications

• SQL querying

• Development of new Talend V7.3 Jobs for data integration from various sources

• Refactoring / Optimization / Maintenance of existing jobs

• Creation of JIRA tickets via API

• Migration of jobs to Azure

• Design, modeling, development, testing, and deployment of Talend workflows

• Unit testing locally

• Acceptance testing of all workflows

• Deployment and scheduling of workflows

• Maintenance and monitoring of workflows

• Data migration

• Automation of Talend workflows

• Scheduling of Talend workflows

• Technical documentation

• Support for RUN and Business teams

Keywords: Talend Open Studio 7.3, ETL Tool, Ctrl-M, DBeaver, MySQL, PostgreSQL, Oracle, AS400 (IBM DB2), Jira, Confluence

❖ Implementation of a new Data Warehouse

• Analysis and comparison of different Data Warehouse and ETL solutions

• Setup of an on-premise server with MySql 8 as a data warehouse

• Development of feeding workflows under Talend

• Import of data into MySql via Talend Jobs from different data sources (Dynamics FO, CRM, Workday, etc.)

• Creation of views and optimization of queries via Index

❖ Reorganization of Self-Service BI on Power BI

• Setup of Workspaces to host reports

• Setup of Dataflows

• Preparation and training of Key Users on report creation

• Setup of a Data Catalog (Azure Purview)

Keywords: Talend Data Integration, Microsoft Power BI, Power Query, Data Analysis Expressions (DAX), Data Warehouse, MySQL, MySQL Workbench, Microsoft Dynamics, Git, Gitlab, Jira

Design of Talend workflows and generation of detailed reports and dashboards.

• Analysis of client needs and proposal of adapted BI/Talend solutions

• Development of feeding workflows under Talend

• Creation of Universes (information design tool)

• Development of reports using BusinessObjects

• Development and evolution of reports under Power BI

• Data manipulation under ADMINER, PgAdmin

Keywords: Talend DI, SAP BO, MySQL, Power BI, pgAdmin

Development and implementation of a decision support system for monitoring a company's revenue.

• Development of feeding workflows under Talend

• Creation of a data warehouse

• Creation of datamarts

• Creation of dashboards under Power BI

• Creation of an OLAP cube under Pentaho

Keywords: Talend DI, MySQL Workbench, Power BI, Pentaho