ETL Experience Front End JavaScript Based Technologies Analyst

Responsibilities

Can work remote but will be required to report onsite on occasion to meet with user groups
Will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture
This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third-party vendor
They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system
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

Skills required Oracle PL/SQL, Query Optimization, Data Migration, ETL Experience Front End JavaScript Base
We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernization initiatives
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

🌟 Can work remote but will be required to report onsite on occasion to meet with user groups
🚀 Will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture
📊 This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third-party vendor
🛠 They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system