Sr. Bilingual Technical Advisor to provide support and contribute to CI/CD process improvement within a Data Warehouse for Large Insurance Client - 694

12 months initially - possible extension
Location: Montreal, QC ; Saint-Hyacinthe, QC ; Toronto, ON (Hybrid as needed)
Language: English & French
Team: Vault Knights
Dept: D&A (Data & Analytics) Production support

Under the Data and Analytics (D&A) Directorate whose goal is to facilitate the consumption of enterprise data. We provide support and maintenance for all databases in this group which ingests all operational data from Intact's applications and transforms it to make it consumable to the ever-growing community of data scientists and actuaries.

Responsibilities

• Supports and maintain the components of the different environments which involves solving complex infrastructure problems, assesses the impact of certain problems and contributes to solutions by developing knowledge base systems for infrastructure management that will be reusable by other teams and departments.
• Manage non-production, Prep and PROD environments on Delphix, D&A development teams to ensure their integrity, safety and quality.
• Provide first-level support for operational incidents related to environments and tools such as Delphix, Oracle, Informatica Power Center, IICS and others.
• Support the continuous improvement of processes by contributing ideas, best practices, improved processes in a new agile approach (DEVOPS)
• Work in partnership with the D&A development teams to set up and support the continuous integration (CI) and continuous deployment (CD) processes
• Contribute to the improvement of the main data quality processes to execute them with simplicity, speed, quality and efficiency.
• Support the organization's production processes related to data warehouses

Must Haves

• 10+ years of experience in a production support environment
• Proficiency with IICS (Informatica Intelligent Cloud Services)
• Experience supporting development teams to set up and support the continuous integration (CI) and continuous deployment (CD) processes
• Experience with Oracle 19C, 12 and PL/SQL
• Experience in the following environments: UNIX, Linux and Windows
• English/French bilingualism

Nice to Haves

• Experience using Informatica Power Center 10.4 Business Object BI tools, Power BI and others
• Experience with SAS EG, SAS Viya SQL server and others
• Experience supporting a Cloud based Intiative (AWS, Azure, etc)
• Experience with Insurance sector