What are the responsibilities and job description for the Database Migration Analyst/Programmer position at Katalyst Data Management?
Job Description
Job Description
Key Responsibilities and Accountabilities
The Database Migration Analyst / Programmer uses their knowledge of Data Model theory and practice, Postgres PL / pgSQL (or Oracle PL / SQL) and SQL to design, execute and confirm the migration from various origin databases into the Katalyst iGlass database (PPDM-based) data model. The Database Migration Analyst / Programmer works under the technical supervision of the Chief Database Architect on operational projects directed by operational Project and / or Account Managers to ensure that client origin data is accurately reflected in iGlass at the end of the migration process. Great organisational ability, a high level of attention to detail, the ability to multi-task, a natural curiosity and a desire to learn are also required for this role.
Key Responsibilities :
- Conduct in-depth analysis and profiling of source data from various systems (e.g., ProSource Seabed, Trango, Petrobank, eSearch, custom databases).
- Collaborate with Account / Project Management teams to develop comprehensive data migration plans, including mapping source data to the iGlass data model.
- Design, code / program, and implement robust data model migration processes using PL / pgSQL, SQL, and industry-standard ETL best practices.
- Create and maintain necessary database objects (tables, views, etc.) within the Postgres environment.
- Develop in-depth expertise in the iGlass data model and its intricacies.
- Perform thorough peer reviews and quality control on the work of colleagues.
- Contribute to research and development projects as needed.
Skills Required :
Required Education and Experience
Occasional regional and international travel may be required.
