Develops basic to moderately complex code using front and / or back end programming languages within multiple platforms as needed in collaboration with business and technology teams for internal and external client software solutions.
Designs, creates, and delivers routine to moderately complex program specifications for code development and support on multiple projects/issues with a wide understanding of the application / database to better align interactions and technologies.
Analyzes, modifies, and develops moderately complex code/unit testing in order to develop concise application documentation. Performs testing and validation requirements for moderately complex code changes.
Performs corrective measures for moderately complex code deficiencies and escalates alternative proposals.
Provides support to leadership for the design, development and enforcement of business / infrastructure application standards to include associated controls, procedures and monitoring to ensure compliance and accuracy of data.
Applies a full understanding of procedures, methodology and application standards to include Payment Card Industry (PCI) security compliance.
Conducts and provides basic billable hours and resource estimates on initiatives, projects and issues.
Assists with on-the-job training and provides guidance to other software engineers.
Qualifications:
Bachelor' s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field and/or 6 – 8 years of development experience using PL/SQL
Very good knowledge of SQL (aggregation functions, Joins and various built-in SQL functions and data types).
Experience in a high volume, highly scalable transaction processing environment.
Sound knowledge of advanced SQL, which includes analytical SQL, hierarchical SQL, dynamic SQLs and regular expressions.
Basic knowledge of Oracle database administrations.
Good knowledge of UNIX commands, basic understanding of Shell scripting.
Good knowledge of Advanced Queuing, DBMS_SCHEDULER and setting up CRON jobs.
Experience with Oracle Database 11g and above
Experience using software development tools including source control (Git, SVN), quality management ( Agile Central), and Continuous Integration tools (Jenkins, XL Release) is a plus.
Experience with Java or other object-oriented languages helpful