Overview
On Site
Contract - W2
Contract - 1 year
Skills
Oracle
SAS
Job Details
Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 25 years.
Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.
Onsite in Downtown NY
Selected Candidate will convert (re-develop) existing SAS technology-based code/ Backend process into an optimized Oracle PL/SQL codebase.
This backend process integrates multiple data-sources, applies data cleansing, massages data, implements business logic & business rules, and prepares data for final reporting.
Selected Candidate will ensure the converted code maintains the functional equivalence or better and performance efficiency of the original SAS code. Vendor Qualifications Experience and Expertise:
The vendor will provide a SAS/Oracle Developer with minimum of 7 years of Oracle PL/SQL and minimum 4 years of SAS development experience.
Developer should have proven track record of successfully converting SAS code to Oracle PL/SQL in similar projects.
Developer should possess a deep understanding of both SAS and Oracle PL/SQL, including their respective strengths, limitations, and best practices.
Developer must have experience with performance tuning and optimization in Oracle database environments.
Developer should have familiarity with data warehousing, ETL processes, and database management.
Developer should have strong problem-solving skills and ability to troubleshoot and resolve technical issues promptly.
The selected developer will perform unit testing, Quality Assurance testing and work with users for UAT testing and remediation. Technical Skills:
Proficiency in SAS programming and Oracle PL/SQL development.
Expertise in SQL and understanding of relational database concepts.
Knowledge of data modeling, database design, and schema creation in Oracle.
Ability to use Oracle development tools and utilities such as TOAD and SAS code Editor effectively. Conditions: ACS will interview and approve the candidate for this position.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.