PL/SQL Developer

Job Title: Data Warehouse / PL SQL Dev.Job Location: Montreal (Onsite - Hybrid)Fulltime with BenefitsJob Summary:SynopsisDevelopment & Support activities of the Commercial Banking application for the leading US Commercial & Investment Bank. The project involved understanding the Commercial banking application's risk & reporting stream used by the business users and supporting/enhancing its Infrastructure e.g. database, critical batches, web servers.My Responsibilities includeTo ensure prompt addressing of financial user's query within defined SLA production support project.To design application architecture, database developer (Oracle/Sybase) and backend developer (Shell scripting/Perl)Batch designing and implementation in Unix/Linux using shell scripting, Perl.To troubleshoot and resolve the batch issues by coordinating with other cross functional teams within the prescribed timelines and make aware of the impact to the business.To work on development part for the enhancement/fixes based on the Business requirement which includes setup batch jobs in Control M, creating/modifying DB objects, Shell scripts.Data processing and complex data calculations in SQL for data warehouse and downstream reportingETL operations and performance tuning the complex SQL and DML queries.To collaborate with business users for requirement gathering involving all SDLC phases.To ensure with the compliance for Incident Management and Change Management.Reviewing and maintaining the Technical/Functional Design documents and operations.To participate in the BCP/DR activities for ensuring the smooth business operations.To leverage the automations for repetitive manual tasks/interventions.Preparing metric reports which includes incidents, outages, efforts, releases for the client.Server migration activities to Linux platformLife at Capgemini:Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:Flexible workHealthcare including dental, vision, mental health, and well-being programsFinancial well-being programs such as 401(k) and Employee Share Ownership PlanPaid time off and paid holidaysPaid parental leaveFamily-building benefits like adoption assistance, surrogacy, and cryopreservationSocial well-being benefits like subsidized backup child/elder care and tutoringMentoring, coaching, and learning programsEmployee Resource GroupsDisaster ReliefAbout Capgemini:Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided every day by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 360,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast-evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported 2023 global revenues of €22.5 billion.Get The Future You Want | www.capgemini.comDisclaimer:Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please get in touch with your recruiting contact.Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law Banking,Financial Services