Oracle & ETL Developer

Overview Impact the Moment McGraw Hill is a diverse and inclusive company that believes we can change the world by leveling the playing field and giving every learner an equal opportunity to succeed. We create best-in-class, next-generation learning platforms which are used by millions of students and educators worldwide. Our goal is to accelerate student success through intuitive and effective learning experiences, to continually reimagine the way our customers teach and learn, simplifying the path to a better education for all. As an education innovation company, we're proud to play our part by inspiring learners around the world. If you bring your curiosity, we'll help you grow in a collaborative environment where everyone shares a passion for success. How can you make an impact? Working as part of the Interface team, the successful candidate 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 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 implement the requirements. Work closely with onshore and offshore development teams to develop a strong understanding of the project and objectives. Interacting with the business requirement team and converting requirements 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. 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. Hands-on experience in writing complex SQL queries. Hands-on knowledge in creating PL/SQL Packages, Procedures, Functions, Triggers, Views, and Exception handling for retrieving, manipulating, checking, and migrating complex data sets in Oracle. 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? The work you do at McGraw Hill will be work that matters. We are collectively designing content that will build the future of education. Play your part and experience a sense of fulfillment that will inspire you to even greater heights. #J-18808-Ljbffr