PL/SQL Developer

Job Title: Datawarehouse Analyst III

• Must be local to Houston or TX and be willing to be in the office Monday, Tuesday, and Thursday of every week

• Develop Oracle PL/SQL applications.
• Create Oracle PL/SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers, types, synonyms based on requirements. Create new applications or enhance existing applications to produce commissions reports.
• Work with Manager/IT Lead to understand requirements, create technical design, analyze source tables and relationships, adhere to consistent coding/SVN standards, and provide daily status updates.
• Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
• Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL/SQL code.
• Optimize code by following performance tuning techniques and coding standards established within the team.
• Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
• Perform Unit testing and end to end System testing of the Oracle PL/SQL application. Prior to UAT submission test and compare the reports to Production calc. reports and identify and fix discrepancies.
• Use analytics skills to troubleshoot and resolve problems quickly
• Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
• Have code reviewed with IT lead prior to moving the code to QA environment
• Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
• Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
• Follow SOX procedures for code deployment.