Data Migration Specialist PeopleSoft (Oracle) to Azure

  • Chicago, IL
  • Posted 1 day ago | Updated moments ago

Overview

On Site
BASED ON EXPERIENCE
Full Time
Contract - W2
Contract - Independent
Contract - 6+ mo(s)

Skills

Data Extraction
Extract
Transform
Load
Data Processing
Collaboration
Cloud Computing
Migration
Data Quality
Database Administration
Data Migration
Oracle
Microsoft SQL Server
SQL Azure
Data Lake
Oracle Data Pump
ADF
Microsoft Azure
SQL
PL/SQL
Data Validation
Testing
Performance Tuning
Problem Solving
Conflict Resolution
Communication
Documentation
Python
Scripting
PeopleSoft
Data Structure
Data Governance
Regulatory Compliance

Job Details

Job Title: Data Migration Specialist - PeopleSoft (Oracle) to Azure
Location:Chicago, IL
Duration : 6+ Months
Exp. Level: 8-12 years

Job Overview:

We are seeking a highly skilled Data Migration Specialist to lead the migration of enterprise data from PeopleSoft (Oracle) systems to Azure SQL Database and Azure Data Lake. This role is ideal for someone with deep experience in database management, cloud migration, and performance tuning, who can work onsite in a collaborative environment.

Key Responsibilities:

  • Lead and execute the end-to-end data migration from Oracle/PeopleSoft to Azure SQL and Azure Data Lake.
  • Utilize tools such as SSMA, Oracle Data Pump, Azure Data Factory (ADF), and Azure Synapse for data extraction, transformation, and loading (ETL).
  • Write and optimize complex SQL and PL/SQL scripts for data processing and transformation.
  • Perform data validation, reconciliation, and performance tuning to ensure data accuracy and efficiency.
  • Collaborate with cross-functional teams including DBAs, cloud architects, and business analysts to ensure smooth migration.
  • Document data mappings, migration processes, and transformation logic.
  • Troubleshoot and resolve issues related to data quality, performance, and compatibility.

Required Skills & Qualifications:

  • 5+ years of experience in database management and data migration.
  • Strong hands-on experience with:
    • Oracle and SQL Server
    • Azure SQL Database and Azure Data Lake
    • SSMA, Oracle Data Pump, ADF, Azure Synapse
  • Proficiency in SQL and PL/SQL scripting.
  • Experience in data validation, testing, and performance tuning.
  • Excellent problem-solving, communication, and documentation skills.

Preferred Qualifications:

  • Experience with Python for scripting and automation.
  • Familiarity with PeopleSoft data structures.
  • Understanding of data governance and compliance frameworks.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About My IT LLC