Programmer Analyst/Data Conversion

Responsibilities

• Review and document existing application architecture, data models, workflows, and stored procedures.

• Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.

• Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.

• Extract, map, validate, and transform data to support ETL and database conversion activities.

• Analyze, document, and refactor core logic modules such as sentence computation.

• Convert legacy DHTML-based UI forms to modern formats as part of system redesign.

• Understand and document scheduled jobs and backend automation processes.

• Collaborate with a third-party vendor to clarify requirements and support modernization efforts.

• Required Qualifications

• Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).

• Strong SQL expertise including query optimization and performance tuning.

• Experience with data migration, ETL workflows, and schema transformation.

• Ability to understand logic from legacy applications and undocumented code.

• Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).

• Experience with task schedulers for data automation.

• 5-7 years of experience in SQL/ORACLE programming, Business Analysis, or related field.