Migration Analyst - Databases

About Inetum, Positive digital flow:

Inetum is an IT services company that provides digital services and solutions and a global group that helps companies and institutions to get the most out of digital flow. The Inetum group is committed towards all these players to innovate, continue to adapt and stay ahead. With its multi-expert profile, Inetum offers its clients a unique combination of proximity, a sectorial organization and solutions of industrial quality. Operating in more than 26 countries, the Group has nearly 27,000 employees and in 2020 generated revenues of €1,965 billion.

Inetum Romania is an important player in the IT services and solutions market in our country, with over 15 years of activity. It is a stable, growing and profitable company with over 500 employees who provides IT consulting services, infrastructure and software development assistance, digital services implementation and support.

In an Agile format, our teams work on cloud initiatives, application development, business intelligence, automation and digitalization projects that contribute to the profit and evolution of our clients. The diversity of our projects offers team members the opportunity for learning and growth. The company had a turnover of 20 million EURO in 2021.

Oracle Database – PL/SQL
Shell Scripting UNIX/LINUX

Analysis and Testing
• Participate to data source analysis, source to target data mapping and migration data model definition.
• Requirements definition and “expected data to be compared” preparation for source to target reconciliation reports
• Participate in overall migration cutover plan preparation involving different teams and organizations
• End to end migration execution for testing purposes
• Multiple testing migration execution for preparing full and low volume data environments together with vendor teams
• Data migration testing, bug reporting and defect tracking
• Migration issues impact assessment and prioritizations
• Reconciliation reports preparation, error investigation and fixing
• Testing support, writing tools for testing automation/assistance
• Create Runbook documents (steps to be run) for various migration activities/phases as input for live migration execution teams

Oracle Database – PL/SQL
• Reconciliation scripts development for migration data validation between source systems and new complex system with new data model based on “expected data to be compared”.
• Scripts development for data validation and cleansing using SQL and PL/SQL to evaluate data quality in the source systems.
• Maintain Migration Databases in terms of preparing schemas for new migration, import/export data for test purposes
• Maintain Databases Passwords, flawless running in terms of performance, load and available space monitoring

Shell Scripting UNIX/LINUX
• Shell scripting (mainly in UNIX OS) to create automatic scripts that executes SQL queries for comparing, exporting and importing data.
• Maintain UNIX servers in terms of user passwords, Public/Private keys, cleaning the directories and organize the space available
• Run scripts, create directories, transfer files and manipulate dumps of data