Data Migration Engineer
Company | CAI |
---|---|
Location | Jackson Township, NJ, USA |
Salary | $Not Provided – $Not Provided |
Type | Full-Time |
Degrees | |
Experience Level | Junior, 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