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 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.
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,
code reviews, 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.
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.
Knowledge/Experience in AWS/Hadoop is a plus.
Strong Team player, and able to work independently.
Should be ready to work in 12 to 9 PM IST shift.
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
Inclusion and diversity are critical to the success of IHS Markit, and we actively encourage applications from people of all backgrounds. We are committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, status as a protected veteran, or any other protected category. For more information on the many ways in which we enthusiastically support inclusion and diversity efforts for both candidates and employees, please access our Inclusion & Diversity Statement here.
We are proud to provide reasonable accommodations to applicants with disabilities. If you are interested in applying for employment with IHS Markit and need special assistance or an accommodation to use our website or to apply for a position, please contact or call +1 212 849 0399. Determination on requests for reasonable accommodation are considered on a case-by-case basis. This contact information (email and phone) is intended for application assistance and accommodation requests only. We are unable to accept resumes or provide information about application status through the phone number or email address above. Resumes are only accepted through the online application process, and only qualified candidates will receive consideration and follow-up.
IHS Markit maintains a substance-free workplace; employees may be asked to submit to a drug test (where permitted by law). In addition, as a federal contractor in the United States, the company participates in the E-Verify Program to confirm eligibility to work.
For information please click on the following links:
IHS Markit Business Code of Conduct
Right to Work
EEO is the Law
EEO is the Law Supplement
If you are currently employed by IHS Markit, please apply internally via the Workday internal careers site.