The existing TRORA application is used by the:

• Financial Management Department,
• Research Department,
• SPW TLPE

The application is obsolete (PowerBuilder) and must be replaced by a new application while maintaining and improving existing processes.

Since TRORA is not able to communicate via WebServices, an intermediate interface was developed and is hosted by the provider NRB to enable communication with WBFIN.

This intermediate interface requires significant maintenance (and costly hosting).

The TRORA application enables integrated management of company aid files for projects related to technological advancements, research, and energy-related fields.

It serves as a central working point from the receipt of files in the form of letters from future beneficiaries through to the payment of expenses linked to validated projects, from an administrative, technical, and accounting perspective. Some advances made within the TRORA application are recoverable. The application therefore also includes a "revenue" section.

The process of migrating data, files, or folders already present in TRORA2.0 to the new TRORA includes copying or migrating files, databases, configurations, or other stored elements, to ensure service continuity and an update without losing important information, while sorting and eliminating duplicates to achieve this migration at the lowest possible cost.

The deliverables expected from the Database Management expert at the end of the mission are:

• A functional and schematic analysis of the data extraction, transformation, and loading approach;
• A workload analysis and a high-level roadmap specifying the expected timeline for migrating all useful data and the documents associated with the files;
• Support to the SPW Digital business and functional analyst in the effort to reconcile data between the old application and the new application;
• A test report between the data and documents to be migrated (old application) and the migrated data (new application);
• All documented scripts for migrating data and documents.

The main tasks include:

• Definition and understanding of business needs and implementation of the structure/categorization of tasks to be accomplished
• Centralization of information and business concepts
• Overall understanding of how Pega works
• Extraction of the data model
• Implementation of complex SQL queries for selecting source data
• Setting up an ETL flow for data extraction via Talend Studio
• Advanced Powershell scripting for organizing data files in JSON format
• Implementation of incremental copy of folders to be migrated
• Jira ticket management for migration follow-up
• Project documentation in Confluence

Mission Objective

The main activities of the mission will be to:

• Analyze the schema of the old TRORA application and the new TRORA application;
• Listen to the business experts of SPW EER and TLPE and the SPW Digital business and functional analyst regarding issues and specifics of the current schema and the transformations performed on the new schema;
• Analyze and document the data migration strategy from the old to the new schema;
• Develop the validation plan for successful data migration;
• Write the migration scripts from the old to the new schema.

Expected Behavioral Skills

• Dynamic and flexible person
• Good communication and assertiveness
• Pragmatic approach to problems and their solutions
• Excellent command of French, strong oral and written communication skills, active listening
• Possesses writing skills (quick and comprehensive creation of summary documentation) and oral skills (welcoming, understanding client needs, responses given to the client)
• Service- and client-oriented: listening, understanding, and responding to the client's needs
• Autonomous and able to work in a team
• Able to analyze problems and demonstrate both attention to detail and synthesis skills
• Respect for rules and procedures

Evaluation Method

The remaining candidates will be invited to an interview before a panel whose composition will be communicated later. The interview may take place remotely if circumstances require.