What are the responsibilities and job description for the Programmer Analyst position at Intelli ERP Software, LLC?
Job Details
Req. | 01 |
Job Title | Programmer Analyst |
Urgent | Yes- Last day sub. Resume 12/04/25-2:00 PM |
Location | Jackson, MS |
Remote | Can work remote but will be required to report onsite on occasion to meet with user groups. Do NOT submit to anyone unwilling to report onsite as needed. Su |
Immigration | USC/ |
Hours | 40 Hours per week |
Project Start | 12/15/2025 or TBD by Client |
Duration | 24 Months |
Work Schedule | M to F-8:00 to 5:00 PM CST |
Salary/Rate- | Prefer W-2 or 1099 or C2C |
SSN-Last 5 Digit Req |
|
Travel | Occasional- Local only |
Client | Direct |
Background | Standard Background Check |
Key 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 Technical Skills
- 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.
Preferred Qualifications
- Experience with AWS database and reporting services.
- Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting experience (Python, PowerShell).
- Experience with Offender Management or enterprise justice systems.
- Experience working with external vendor teams on modernization projects.