Posted in

Data Migration Engineer

Data Migration Engineer

CompanyCAI
LocationJackson Township, NJ, USA
Salary$Not Provided – $Not Provided
TypeFull-Time
Degrees
Experience LevelJunior, Mid Level

Requirements

  • Proven experience in COBOL programming and Oracle PL/SQL development
  • Strong understanding of SQL and database management systems, particularly Oracle 19c
  • Experience with database design and optimization techniques
  • Strong problem-solving skills and attention to detail
  • Excellent communication and teamwork skills
  • Ability to work independently and manage multiple priorities in a fast-paced environment

Responsibilities

  • Analyze existing COBOL batch applications that are heavily SQL-based to understand their functionality and business logic
  • Design and implement conversion strategies to migrate COBOL applications to Oracle PL/SQL 19c
  • Develop, test, and deploy Oracle stored procedures to replace COBOL batch processes
  • Optimize SQL queries and PL/SQL code for performance and scalability
  • Collaborate with business analysts and stakeholders to ensure the converted applications meet business requirements and maintain data integrity
  • Troubleshoot and resolve issues related to the conversion process and post-migration
  • Document new processes and ensure that all converted applications are well documented for future reference and maintenance
  • Provide training and support to team members and other staff on the new PL/SQL processes
  • Work with testing teams to ensure that all converted applications are thoroughly tested and meet quality standards

Preferred Qualifications

  • Experience in large-scale data migration projects
  • Experience with other modern programming languages and tools, such as Java and Eclipse