This PL / SQL Developer will own, support, investigate, audit, analyse and evaluate daily production operation deliverables processes and their related outputs in our Data Factory.
The Analyst 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.
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.
Works within a specific combination of computer hardware, operating system, and / or compiler configurations. (e.g. : MVS running TSO and / or JES2, UNIX running Solaris and Oracle, Excel Macro, Cognos Cube Transformer, MS SQL Server).
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.
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, 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
We are proud to be an EEO / AA employer M / F / Disability / Veterans. Please refer to the EEO is the Law Poster & Supplement, Right to Work and Pay Transparency Policy.
IHS Markit is a participant in E-Verify (see links below) . We maintain a drug-free workplace and perform pre-employment drug testing.
EEO is the Law
EEO is the Law Supplement
If you are currently a colleague with IHS Markit please apply internally via Workday.