| ( Locals to Houston, Texas only ), Senior Oracle PL/SQL developer Houston, Texas( onsite with hybrid( 1-2 days from office location) 12+ months contract at Houston, Texas, USA |
| Email: [email protected] |
| Hi All, Please find the role below and let us know if you have suitable profiles. Job Title: Senior Oracle PL/SQL developer Houston, Texas( onsite with hybrid( 1-2 days from office location) 12+ months contract Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization. Essential Duties/Responsibilities: Develop Oracle PL/SQL applications. o Code packages, stored procedures, functions, objects, tables, views, synonyms based on requirements. Understand functionality of existing applications and either incorporate new functionality to automate the calculations process or build new applications for the calculations process. o Work with IT Technical Lead to understand requirements/technical design, understand the source tables and relationships, adhere to consistent coding/SVN standards, do code reviews, and provide daily status updates. o Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations. o 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. o Optimize code by following performance tuning techniques considering limitations of current environment. o Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code. Use analytics skills to troubleshoot and resolve problems quickly o Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team. o Have code reviewed with Technical lead prior to moving the code to QA environment o Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled. o Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests. o Follow SOX procedures for code deployment. Perform production support. o Monitor batch processes daily/weekly/monthly and resolve job failures as quickly as possible. o Work with ControlM/Redwood group on re-run/re-start instructions. o Be willing to perform this off hours during weekdays and weekends. o Fulfill ad-hoc requests for data pulls, updates or minor enhancements. Work effectively in a team environment. o Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups. o Independently work on tasks without step by step Supervision o Communicate progress or issues clearly either verbally or through email. o Escalate issues or delays that would impact deadline as early in the process as possible. Work in an office environment twice a week Education: Bachelors degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience. Experience: Experience including but not limited to - 15+ years of experience in Software development - 12+ years of experience in Oracle 12c or 19c - 12+ years of experience in Oracle PL/SQL development including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning - 3+ years of experience in a Data Warehouse environment - Strong Analytical skills - Troubleshooting skills o Team Player Kind Regards , Ashwa Mohan Delivery Lead- US Process ( Recruitment) An ISO 9001:2015 Certified Company and Proud Member of NASSCOM Phone: 919 439 3682 extn 9014 Email: [email protected] LinkedIn : linkedin.com/in/mohan-kumar-b7949444 Our Locations: India | USA | UK www.infomericainc.com Follow us This e-mail, and any attachment, is confidential. If you are not the intended recipient, please delete it from your system, do not use or disclose the information in any way, and notify the sender immediately. Any views expressed in this message are those of the individual sender and may not be the views of Infomerica, unless specifically stated. No warranty is made that the e-mail or attachment (s) are free from computer viruses or other defects. -- Keywords: quality analyst active directory information technology procedural language |
| [email protected] View all |
| Mon Dec 11 20:30:00 UTC 2023 |