EG
Manufacturing Engineering Support Rework Order position at Expleo working on complex technical challenges. Collaborate on innovative solutions in a dynamic work environment ML. All. 5 paid personal days.
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.
EG
Manufacturing Engineering Support role at Expleo in Mirabel, QC. Focus on innovative manufacturing solutions and collaboration in aerospace projects.
LP
Document Solution Lead
LinkedIn Recruiter Post
We are hiring an experienced Document Solution Lead with strong expertise in SmartCOMM and enterprise document generation solutions for an 8 - month hybrid contract in Toronto, ON.
LP
Senior Data Architects
LinkedIn Recruiter Post
Senior Data Architects for a provincial government contract. Must be in Alberta and able to work onsite in Edmonton monthly.
Engineer driving the evolution of OrioleDB and collaborating with the PostgreSQL community at Supabase. Design and implement new database features and ensure system reliability.
Senior Mobile Engineer responsible for building and evolving Cardata's driver app with a focus on React Native and native code. Contributing to AI - driven workflows and ensuring high - quality standards in a collaborative environment.
Développeur logiciel contributeur à l'outil de migration ShareGate de Workleap. Livrer des fonctionnalités et moderniser le code tout en collabore avec son équipe.
LP
SRE Lead
LinkedIn Recruiter Post
Hiring SRE Lead for 12 - month hybrid contract in Toronto, ON. Requires deep expertise in Observability, Dynatrace, and large - scale enterprise systems.
AI Engineering Intern developing AI agents and supporting real - world deployments for customer environments at Cresta, utilizing Large Language Models and innovative solutions.
Applications Development Senior Programmer Analyst at Citi enhancing application systems and contributing to programming activities in team - oriented environment.