ID
#17568967
Job type
Contract
Salary
Depends on Experience
Source
Infomerica, Inc
Date
2021-07-13
Deadline
2021-09-11

Senior Oracle PL/SQL Developer

Texas, Houston, 77001

Contract

Vacancy expired!

Required Experience:

15+ years of experience in Software development
12+ years of experience in Oracle 10g or 11g
12+ years of experience in Oracle PL/SQL development including experience using advanced features
3+ years of experience in a Data Warehouse environment
Experience on building batch application, Oracle scheduling, experience on building packages, writing complex queries, partition experience at table level
Energy domain experience is plus
Strong Analytical skills
Troubleshooting skills
Team Player Additional skills:
Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must.
Excellent verbal and written communication skills are required in order to interact with other team members, Team Lead, End user, Business, Project Manager, and other teams.

Essential Duties/Responsibilities:

Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.
Develop Oracle PL/SQL packages, stored procedures, functions, objects, tables, views, synonyms based on requirements.
Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code.
Optimize code by following performance tuning techniques considering limitations of current environment.
Use Oracle Analytical functions, merge statements, with clause, oracle partitioning, job logging, exception handling, performance tuning and so on in the Oracle PL/SQL code.
Use analytics skills to troubleshoot and resolve problems quickly
Work with Team Lead and other members of the Commissions IT team to understand requirements, identify source data, understand the source tables and relationships, adhere to consistent coding standards, do code reviews, and provide daily status updates.
Work with the Commissions Project team to understand the reporting requirements for each workstream and build, test, and UAT according to their expectations.
Work effectively in a team environment. Develop strong working relationship with members of Commissions IT team, Commissions Project team, Project Management team, and Business.
Get familiarized with the ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
Experienced in any source code versioning tool
Follow SOX procedures for code deployment.
Create ControlM job documents and work with ControlM to get them created and scheduled.
Monitor batch processes daily/weekly/monthly and resolve job failures as quickly as possible. Work with ControlM group on re-run/re-start instructions. Willingness to perform this off hours during weekdays and weekends.
Provide production support of the application and satisfy requests for data updates, ad-hoc reports or minor enhancements.
Communicate status and escalate issues or delays that would impact deadline as early in the process as possible.

Education:

Bachelor’s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.

Vacancy expired!

Report job