Job Description

This PL/SQL Developer will own, support, investigate, audit, analyze and evaluate daily production operation deliverables processes and their related outputs in our Data Factory.  The developer will also assist in Design, development, implementation and support of new or migrated production processes.   You will work with large amounts of data that feed into our IHS Automotive data products.
 
Primary Responsibilities

Should be able to perform a mix of roles and operating in both the Oracle and S3 space.

This role includes BA/QA tasks of the data, Assembly code development/testing and working to complete onboarding with other support teams (ETL/DBA) for code changes,

deployments and other issues encompassing both onboarding and operational as they occur.

Maintains applications according to requirements, which may involve modifications on existing job scripts, data scripts, and workflow/packages.
Develop scripts according to the business specifications/designs.
Assesses risk associated with implementations and develops “back out” plans prior to implementing changes in production.  Anticipates problems and proposes multiple solutions.
Conduct data analysis to support business requirements, can transfer design concepts across environments.
Prepare data and programs to produce both cyclical and adhoc customer deliverables and reports, with existing checklist/procedure documents
Prepare technical documents, specification documents/diagrams, logic flowcharts, etc. of program development, subsequent revisions, application run-book, and procedures/checklists.
Effective decisions that may measurably impact work assignments, scheduling and the daily planning of work
Validate that production moves are executed appropriately, monitors production process after release to ensure accuracy and efficiency.
Investigates client questions and performs data analysis to understand the application or data issue independently, or with support and direction from the SME for complex issues.
Continuous product improvement through maintenance activities on existing products to correct errors in the original implementation, adding new features or re-architecting areas for performance improvement
Determines the approximate size and complexity of tasks in relationship to defined customer requirements.  Calculate time, steps involved and deadlines for assigned projects.  Utilizes historical project data to improve the accuracy and consistency of the estimates and plans.
Interprets and uses computer operating systems and interface tools to code, compile, test, run, and debug programs (e.g., PLSQL, UNIX Scripts, Windows, etc).
Carries out activities to migrate existing PLSQL packages into streamline approach, e.g. using of Control M procedures, UNIX Scripts and framework.
Informs appropriate personnel within the Company about events that will affect them.
Builds and maintains internal relationships within and across other internal teams. Gains an understanding of how the end customer uses the data within their business.
Monitors production process after release.
Creates complete project documentation to include job steps, input/output files, flowcharts, parameter definitions, job prerequisites, interfaces, operational instructions and troubleshooting information.

 
Minimum Qualifications

Bachelor’s degree in Computer Science with two to four years’ related job experience or equivalent combination of education and experience.
Advanced languages skills in PL/SQL.
Knowledge/Experience in AWS is a plus.
Strong Team player, and able to work independently.
Strong conceptual thinking.
Strong Analytical skills.
Ability to effectively communicate technical concepts or problems to non-technical peers.
Ability to document processes, procedures, and checklist.
Strong understanding on delivery to a service delivery agreement (SLA)
Strong interpersonal, written and communication skills.
Experience on supporting deliverables with large volume of transactional data, strong data analysis skill is a definite asset.
Ability to learn new concepts quickly and independently.
Capable of working under pressure and tight deadline, balancing multiple assignments simultaneously.
A general understanding of the automotive business.
A general understanding of data files and common data processing functions.
Understands the methodology to define, analyze and design an automated solution.
Understands sequential, indexed, random and/or relational file access methods and how they can be applied.
Must be able to effectively communicate technical information to both technical and non-technical personnel.
Proficient at using testing tools (Debugger).
Proficient at auditing data and interpreting the results.
Familiarity with code repository software such as (SVN,GIT etc.) is a bonus
Possesses knowledge of hardware and operating system capabilities in multiple environments.
Understands connections between platforms and how to move data between them.
Familiarity in navigate/operate platform specific command sets, utilities, and tools (e.g: FTP, SFTP, UNIX file networking/sharing).
Strong skills in accessing data within Oracle databases using tools such as (Toad, SQL Developer, etc).
Familiarity in creating visualizing and analyzing data using Excel and Tableau a plus