PL/SQL Developer
Apply NowCompany: CAPGEMINI ENGINEERING
Location: Toronto, ON M4E 3Y1
Description:
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Job Description
Strong experience in design and implement data pipelines
Strong PL/SQL and SQL skills in relational database environment
Strong Unix shell scripting skills
Create and review technical design documents, understand how the design will be used in the code development process, and facilitate meetings to design, troubleshoot, and execute projects
Participate in walkthrough reviews of technical specifications, programs, code, and unit test plans
Plan design/implementation activities, ensure technical solution quality, provide third-level support for various technologies, and drive technical platform evolution and improvements
Present technical topics at regular team meetings and manage low-level planning of work packages
Estimate activities/tasks required to perform design, coding, and unit testing
Excellent interpersonal and highly developed communication skills (verbal and written)
Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
Work closely with development teams to learn about needs, current processes and to promote best practices.
Knowledge of the Software Development Life Cycle (SDLC) - Agile, Waterfall, and Iterative methods
Working knowledge GitHub, CI/CD Pipeline
Must Have:
8+ years of experience working in complex and time-sensitive development environment
Extensive hands-on experience in ETL data-stage
Extensive hands-on complex SQL experience (MSSQL Server, Teradata)
Extensive experience in creating stored procedure and Unix shell scripting
Support at-scale testing to enable simulations, UAT and reporting
Disclaimer
Capgemini is an Equal Opportunity Employer
Encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, sex, gender identity or expression, age, religion, disability, sexual orientation, genetic information, citizenship status, veteran status, marital status, or any other characteristic protected by applicable 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.
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of 22.5 billion.
Job Description
Strong experience in design and implement data pipelines
Strong PL/SQL and SQL skills in relational database environment
Strong Unix shell scripting skills
Create and review technical design documents, understand how the design will be used in the code development process, and facilitate meetings to design, troubleshoot, and execute projects
Participate in walkthrough reviews of technical specifications, programs, code, and unit test plans
Plan design/implementation activities, ensure technical solution quality, provide third-level support for various technologies, and drive technical platform evolution and improvements
Present technical topics at regular team meetings and manage low-level planning of work packages
Estimate activities/tasks required to perform design, coding, and unit testing
Excellent interpersonal and highly developed communication skills (verbal and written)
Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
Work closely with development teams to learn about needs, current processes and to promote best practices.
Knowledge of the Software Development Life Cycle (SDLC) - Agile, Waterfall, and Iterative methods
Working knowledge GitHub, CI/CD Pipeline
Must Have:
8+ years of experience working in complex and time-sensitive development environment
Extensive hands-on experience in ETL data-stage
Extensive hands-on complex SQL experience (MSSQL Server, Teradata)
Extensive experience in creating stored procedure and Unix shell scripting
Support at-scale testing to enable simulations, UAT and reporting
Disclaimer
Capgemini is an Equal Opportunity Employer
Encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, sex, gender identity or expression, age, religion, disability, sexual orientation, genetic information, citizenship status, veteran status, marital status, or any other characteristic protected by applicable 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.
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of 22.5 billion.