SAS Oracle PL / SQL

Hi

Please review and let me know your thoughts

This job is new with a city agency

Is on site downtown NYC

$70-75W2 must be our W2

SAS / Oracle Developer who will be responsible for converting SAS code into Oracle database Tables, views, procedures, packages and functions.

Developer also will be helping to create, design, database tables, Develop packages, stored Procedures, and functions with industry standard and make sure queries performance is optimal.

Scope of Work

• 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 :
• Client will interview and approve the candidate for this position.
• Client reserves the option to replace the developer if the person does not meet the qualifications and / or does not demonstrate these qualifications while onsite.

Thank you!

Jackie

Jackie Flynn

Director of Recruiting

TNT Staffing LLC

70 Kinderkamack Road, Suite 100

Emerson NJ 07646

(201) 497-6305 x 403 Office

(201) 574-3889 Cell

(201) 754-9755 Fax

Jackie@tntstaffing.com