Advansoft International - Arlington Heights, IL

posted 22 days ago

Full-time
Arlington Heights, IL
Professional, Scientific, and Technical Services

About the position

As a PL/SQL Developer at AdvanSoft International, you will play a crucial role in the data migration and conversion processes. Your primary responsibility will be to create detailed mappings between old and new data elements, ensuring that all business rules are verified and clarified through user contact. You will participate in various business process evaluation and improvement activities, which include requirements gathering, system analysis, and system design. Your expertise in PL/SQL will be essential as you execute projects based on these activities, contributing to the overall efficiency and effectiveness of the data migration process. In addition to your core responsibilities, you will also be involved in the evaluation and implementation of third-party software solutions as needed. You will develop standardized procedures for common conversion routines, which will help increase efficiencies across the board. Data verification will be a critical part of your role, as you will ensure that all data is accurately migrated to the target system. You will develop a comprehensive plan for live conversion, which includes obtaining live data from the current system and running conversion programs. Post-conversion, you will verify the converted data with customers and provide support to address any questions or problems that may arise. Your role will also involve post-conversion testing, where you will test the converted data according to the established test plan. Additionally, you will be responsible for developing and maintaining utility programs or scripts to automate common pre/post conversion tasks, further enhancing the efficiency of the data migration process.

Responsibilities

  • Create detailed mapping between old data elements and new data elements and contact users to verify business rules and/or clarify data analysis.
  • Participate in business process evaluation/improvement activities, requirements gathering, system analysis, system design, software/hardware applicability studies and system implementation.
  • Participate in the evaluation/implementation of third party software solutions when requested.
  • Develop standardized procedures for common conversion routines to increase efficiencies.
  • Perform data verification and ensure all data is migrated to target system accurately.
  • Develop plan for the live conversion and obtain customers live data from the current system and run conversion programs.
  • Verify converted data with the customers and provide post conversion support to answer questions and address problems if they arise.
  • Provide post conversion testing and test the converted data as per the test plan.
  • Develop and maintain utility programs or scripts to automate common pre/post conversion tasks.

Requirements

  • Bachelor's level training in Information Systems, Computer Science, Computer Applications, or a related Engineering discipline, or equivalent experience.
  • Proficiency in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Analytical Functions, Packages, and creation of Oracle Objects such as Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables, and Collections.
  • Experience with Oracle Database and MarkLogic Server, including using MLCP.
  • Familiarity with Microsoft Windows, Word, and Excel.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service