Senior Application Developer – DataStage and Mainframe – Royal Bank of Canada

Title of the Job: Senior Application Developer – DataStage and Mainframe

Location: Toronto, ON

Job Description: Job SummaryJob DescriptionWhat is the opportunity?A Senior Developer in application development within Enterprise Technology, Digital. Provides information on the detailed technical design and development of applications using existing and emerging technology platforms. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.What will you do?You will be required to collaborate with multiple project/program stakeholders, including the Business Units, Project Managers, Architects, Business Systems Analysts, Development, Quality Assurance, IT infrastructure teams and third party vendors.Provide thought leadership and be responsible for the highly efficient ETL solutions and design.Design application and Database solutions and provide technical direction while building scalable, high performing reusable solutionsProvide technical direction, anticipate/obtain resolution of issues & implement solutions for the integration of Data projects into Enterprise Technology & RBC’s infrastructure environmentDefines/Supports application SLAs from Database solutions perspectiveProvides work estimates using fact/metrics based model with supporting assumptionsResolves complex issues and conflicts (including architectural direction vs project constraints); escalates to executive level where requiredDesigning and coding application programs; performing testing for developed applications.Reviewing, analyzing, and modifying programming systems, including encoding, testing, debugging and installing for a large-scale system.Ensuring the operating efficiency of existing application systems. Maintaining records for the documentation of systems development and revisions.Conducting analyses of organizational needs and goals for the development and implementation of application systems.What do you need to succeed?Must-have:Mainframe Skills (JCL, COBOL, ZEKE, etc.), with minimum of 5+ years experienceMinimum of 5+ years of recent experience and expert knowledge of designing, developing, deploying, and supporting IBM DataStage (11.x), computing applications in a large-scale, midrange, and distributed environment. In depth experience in troubleshooting of DataStage jobs and addressing issues like performance tuningKnowledge of advanced concepts of ETL processing and of using DataStage, including it’s integration with other technologies like API calls and databases. With minimum of 3+ years as a Senior DeveloperExpertise in designing DataStage Parallel Jobs, Job Sequencing, Creating Parameter Sets, Container, Environment Variables and Creating Parallel Routines, Data Cleansing and Writing Transformation expressions to derive values and remove unwanted data. Also, should have good working knowledge in different stages like Transformer, look up, merge stage, ODBC connector, Oracle connector, Hierarchical Stage etc.Strong SQL, and Linux skillsProven project participation and delivery experience leading team of developers, while coming up with best practices & standards and incorporating then project execution, including their measurement and reporting.Proven experience of incorporating reusability/framework in designs, their adoption, tracking and reportingNice to have:Exposure to DevOps automation tools (example: Helios, UrbanCodeDeploy, GitHub)Understand IT Standards, AGILE Methodologies, System Development Life Cycle (SDLC) and ITIL processesHands-on recent experience of delivering streaming solutions using Kafka and Java based solutions, enterprise grade Database systems (DB2, Teradata, Oracle)Knowledge in JAVA programming and familiarity with any Cloud Technologies is an added advantageStrong understanding of Data warehousing concepts.Strategic thinker with excellent interpersonal skills to work across functions and businesses.Ability to facilitate between and influence key decision makersWhat’s in it for you?We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicableLeaders who support your development through coaching and managing opportunitiesAbility to make a difference and lasting impactWork in a dynamic, collaborative, progressive, and high-performing teamOpportunities to do challenging workOpportunities to take on progressively greater accountabilitiesOpportunities to building close relationships with clientsAccess to a variety of job opportunities across business and geographiesJob Skills Active Learning, Agile Methodology, Analytical Thinking, Application Integrations, Cobol Mainframe, Data Analysis, Design Applications, Detail-Oriented, Documentations, Enterprise Application Delivery, Enterprise Technologies, ETL Processing, GitHub, Group Problem Solving, IBM InfoSphere DataStage, Job Control Language (JCL), Mainframe Programming, Postman (Software), Programming Languages, Software Development Life Cycle (SDLC), Technical DesignsAdditional Job DetailsAddress: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOCity: TORONTOCountry: CanadaWork hours/week: 37.5Employment Type: Full timePlatform: TECHNOLOGY AND OPERATIONSJob Type: RegularPay Type: SalariedPosted Date: 2024-08-21Application Deadline: 2024-10-25Inclusion and Equal Opportunity EmploymentAt RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.Join our Talent CommunityStay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at .

Company Name: Royal Bank of Canada

Salary:

Apply for the job!