Description

You will lead the technical conversion of SAS codebases into optimized Oracle PL/SQL.

Responsibilities

• Analyze existing SAS code, including macros, data steps, and external dependencies, to design a technical conversion plan.
• Rewrite SAS logic into Oracle PL/SQL, ensuring all functionalities are accurately translated and optimized for Oracle architecture.
• Execute parallel testing to validate that converted PL/SQL produces identical results to the original SAS code.
• Optimize PL/SQL code to meet or exceed original performance benchmarks.
• Document the new architecture through data flow diagrams, architecture diagrams, and code annotations.
• Provide training and knowledge transfer to the development team and offer one month of post-implementation support.

Required Skills

• 5+ years of experience in SAS programming and Oracle PL/SQL development.
• Expertise in SQL and relational database concepts.
• Proficiency in Oracle database environments and development tools.
• Strong background in data modeling, database design, and schema creation in Oracle.
• Experience with ETL processes, data warehousing, and database management.
• Proven ability to perform performance tuning and optimization in Oracle.
• Demonstrated experience managing project timelines and technical delivery.
• Ability to handle sensitive data following industry security and compliance standards.
• Any Graduate degree.

Key Skills

Education

Any Graduate