Junior Windchill Developer at Capgemini Engineering working on customizing and maintaining Windchill PLM systems with a focus on Java development and collaboration with senior developers.
About the role
- PL/SQL Developer focusing on Oracle SQL and ODI with experience in relational databases and data warehousing. Collaborating on project delivery with strong data modeling and integration skills.
Responsibilities
- Develop and maintain PL/SQL code and ODI mappings.
- Handle flat files and other file-based sources through ODI.
- Monitor and analyze database performance and reliability.
- Collaborate with architects and teams for project delivery and knowledge sharing.
Requirements
- Strong design and development experience in Oracle SQL, PL/SQL, and Oracle Data Integrator (ODI) 11g & 12c.
- Experience in Oracle database design and data modeling.
- Good understanding of OLTP transaction processing and how operational data is modeled and handled in relational databases.
- Good understanding of financial data, metrics, and reporting requirements.
- Strong experience in creating ODI mappings, interfaces, and ODI procedures.
- Experience handling flat files and other file-based sources/targets through ODI, including file ingestion, transformations, and error handling.
- Understanding of OLAP concepts and processes.
- Experience monitoring, analyzing, and tuning reliability and performance for databases and ETL processes.
- Ability to develop strategies to resolve issues and implement preventive measures to avoid future occurrences.
- Data warehouse lifecycle management experience from design to implementation, including dimensional data modeling.
- Experience with normalized OLTP, MDM, and dimensional modeling techniques, including Star and Snowflake schemas, slowly changing dimensions, dimensional hierarchies, and data classifications.
- Experience maintaining, scaling, supporting, and expanding data persistence platforms using data integration tools and processes to populate and enhance reporting in distributed environments.
- Working knowledge and understanding of the OBIEE Suite (OBI Server, Dashboards, and Analytics).
- Knowledge of data modeling tools such as Oracle Designer, ERwin, TOAD, and DB Artisan.
- Experience working closely with architects, team members, and management to increase delivery capacity for existing and upcoming projects, enable knowledge sharing, and provide depth in data warehousing, data integration, and BI solutions.
- Exposure to the full software development lifecycle and AGILE/Scrum practices.
- Effective verbal and written communication skills with both technical and non-technical stakeholders.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior C# Developer contributing to CBC/Radio - Canada's OTT Team with software development. Designing and modifying components for digital platforms, ensuring high performance and quality.
Developer, Co - op for CARFAX Canada involving hands - on development and collaborative projects. Engage in meaningful work with an enthusiastic team in a tech - focused environment.
LP
Senior Software Developer – Front End
LinkedIn Recruiter Post
Senior Front - End Developer needed for a 6 - month contract with the City of Toronto. Must have React, Backbone, and accessibility expertise.
LP
Software Developer – Back End – Senior
LinkedIn Recruiter Post
Senior Back End Developer needed for contract in Toronto. Must have 8+ years Azure, containerization, and DevOps experience.
LP
Lead Software Engineer / Technical Lead (Java)
LinkedIn Recruiter Post
Hiring a Lead Software Engineer / Technical Lead (Java) for a Capital Markets tech team in Toronto. Hybrid role requiring Java, Spring Boot, and leadership skills.
LP
UAT Lead AML
LinkedIn Recruiter Post
Hiring UAT Lead AML in Toronto, ON (Hybrid). Requires 8+ years UAT/Test Management and AML/banking expertise.
LP
Banking Associate-Wealth Management
LinkedIn Recruiter Post
Banking Associate for Wealth Management needed to process high - volume transactions and support cash in/out requests.
LP
Supervisor, Procurement
LinkedIn Recruiter Post
Supervise procurement operations for the Town of Oakville, ensuring compliance with bylaws and trade agreements.
LP
Service Representative
LinkedIn Recruiter Post
Service Representative needed to manage ATM deposit/payment activities, support transaction processing, and ensure compliance. Pay: $17.60 - $23.19/hr.