SAS/Oracle DeveloperLocation: New York, NYDuration: 6 MonthsScope of WorkSelected 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.QualificationsExperience 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 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.