Aliou SOW

1. Target audience • Tax officials • Future civil servants at the National School of Administration • Data management, analysis managers within tax administrations 2. Content • Definition, importance of BI • Data collection, storage, processing, analysis • Excel, Tableau, Power BI Data collection, management • Identification of internal, external data sources •Techniques for ensuring data quality, integrity Data visualization • Principles of effective data visualization • Creation of interactive dashboards

• Migration from SAP Data Services to Talend DI 7.3 and Talend DI 7.3 to Talend DI 8. 0 • Installation, configuration and parameterization of the Talend and Git platforms and their administration • Gathering and analysis of requirements from the Jira interface, Evolutions, Job corrections Talend of the two Talend Versions, Job development and optimization Environment : Talend DI 7.3 / Talend DI 8.0, Oracle 18, Sql developper, Git, Jira, Nexus, SVN, Confluence, Webservices, Liquibase, RunDeck.

• Installation, configuration and parameterization of Talend and Git platforms and their administration • Rework, design and development of new job interfaces and their publication in TAC and Git; • Development of jobs with the Talend ETL to feed the target interfaces; • Unit testing in DEV, UAT, BENCH and Production for Talend 7.3 Environment: Talend DI 6.4 / Talend DI 7.3, Nexus, Oracle 12, Sql server 18.2, Sql Management Studio, Sql developer, Git, Jira, Confluence, Webservices, Winscp, VTOM

• Analysis of data and needs • Recovery, design and development of new interfaces for ingestion and broadcast jobs • Optimization of jobs; and Writing of technical documentation for developed jobs Python: Importing modules and libraries, Creating modules, Managing errors and exceptions, Automating processes • Tests in Acceptance, Pre-production and Production Environment : Talend Big Data DI 7.2, Gitlab, MongoDB, Kafka, CI/CD-Pipeline, Docker, VS Code, Webservices, XML, Salesforce, SoapUI, Ubuntu