What are the responsibilities and job description for the Programmer position at i3Tech?
Pay: $60/hr (1099)
Location: Las Vegas (100% on-site; local candidates only)
Duration: Feb 2025 - June 2025, with possibility of extension
1. Required Skills and Qualifications:
o Proficiency in Oracle’s PL/SQL is essential (minimum of 10 years of experience)
o Experience with data warehousing concepts and ETL processes.
o Experience with UNIX Shell scripting and Scheduler jobs (Cosmos or Automate).
o Experience with SQL*Loader and mod_plsql package.
o Strong analytical and problem-solving skills.
o Ability to work independently and in a team environment.
o Excellent communication skills to interact effectively with technical and non-technical stakeholders.
o Prior experience in ERP data integration projects is a plus.
o Ability to pass a background check.
Project Overview:
o The IT Programmer will be responsible for upgrading (or creating new) Oracle database and data warehouse views, stored procedures, Unix Shell scripts, batch jobs, and other items from multiple legacy, on-premises Oracle databases (12c and 19c) to our new, cloud-based ERP database solution (Oracle 19c).
Key Responsibilities:
o Develop new PL/SQL queries, scripts, and stored procedures to support data integration between the legacy data warehouse and the new ERP.
o Modify and optimize existing PL/SQL code to improve performance and functionality.
o Collaborate with the project team to understand requirements and translate them into technical solutions.
o Perform data analysis and validation to ensure accuracy and completeness of data transfers.
o Document all developed code, scripts, and procedures thoroughly.
o Troubleshoot and resolve issues related to data integration and interface functionality.
Job Types: Full-time, Contract
Pay: $60.00 per hour
Expected hours: 40 per week
Compensation Package:
- 1099 contract
Application Question(s):
- Where do you currently live?
Experience:
- Oracle PL/SQL: 10 years (Required)
Ability to Commute:
- Las Vegas, NV 89119 (Required)
Work Location: In person
Salary : $60
