Logo
TNT Staffing LLC

SAS Oracle PL/SQL

TNT Staffing LLC, New York, New York, us, 10261

Save Job

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