Oracle & ETL Developer

Job title:

Oracle & ETL Developer

Company

McGraw Hill

Job description

Job Description:OverviewImpact the MomentDo you enjoy testing the limits of possibility? At McGraw Hill, our Global Technology Services organization drives progress and help build the future of learning. If you have the passion and technical expertise to thrive in an innovative and agile environment, we want to learn more about you.Your impact on the teamWorking as part of the Interface team, the Oracle & ETL Developer provides hands-on support to our internal business units. Working closely with Salesforce, business and other technology teams to build robust solutions. The team environment is extremely innovative, intellectually challenging and very dynamic. Research, troubleshooting, analytical, technical and soft skills are a must. The ability to work collaboratively or on your own, being highly motivated with a great work ethic to drive and succeed. Focus on quality and service delivery, with an eye for attention to detail.This is a hybrid position for candidates located in the Greater Toronto Area and open to applicants authorized to work for any employer within Canada.What can you expect from the position?

• Addressing the defects and Change requests and working closely with SA, BA and Testing team to implementing the requirements.
• Work closely with onshore and offshore development teams to develop a strong understanding of the project and objectives.
• Interacting with business requirement team and converting requirement into TSD.
• Driving the end-to-end delivery of the functionality until production release.
• Review unit and integration testing scope for business requirements.
• Performance tune SQL’s, application programs and instances.
• Develop and manage ETL workflows for data integration and transformation tasks, leveraging tools such as Informatica along with Oracle database features such as stored procedures, functions, and packages.
• Providing technical assistance, problem resolution and troubleshooting support.

What can you bring to the role?

• Total 4-5 years of experience with application development on Oracle RDBMS, SQL, PL/SQL.
• Recent hands-on experience with ETL development using tools like Informatica or similar (e.g., Talend, SSIS, Pentaho, or ODI), with proven ability to develop, test, and deploy ETL workflows and mappings.
• Hands-on experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Hands on Experience in writing complex SQL queries.
• Query optimization and performance tuning using indexing, partitioning, query tracing, explain plan, gather stat, hint, analysis of ADDM & AWR report, collection etc.
• Experience in Data migration at application/DB version level.
• Experience in development & low-level design of solutions.
• Hands on experience in frequent code deployment into multiple environments.

Why McGraw Hill?We have a collective passion for the work we do and a curiosity to find new solutions. If you share our determination, together we will drive learning forward.The base pay offered may vary depending on job-related knowledge, skills, experience, and location. Additionally, a full range of medical and/or other benefits may be provided, depending on the position offered.McGraw Hill recruiters always use a “@mheducation.com” email address and/or from our Applicant Tracking System, iCIMS. Any variation of this email domain should be considered suspicious. Additionally, McGraw Hill recruiters and authorized representatives will never request sensitive information in email.48140

Expected salary

Location

Toronto, ON

Job date

Fri, 28 Feb 2025 01:58:23 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (globalvacancies.org) you saw this job posting.