About the role

  • Database Developer designing and maintaining database systems for a global financial services firm. Responsibilities include database optimization, data integration, and collaboration with stakeholders in Montreal.

Responsibilities

  • Design and implement logical and physical data models to support business requirements
  • Develop, optimize, and maintain database schemas, tables, views, and stored procedures
  • Collaborate with stakeholders to gather and analyze data requirements
  • Ensure database performance through query optimization and indexing strategies
  • Implement and maintain ETL processes for data integration and transformation
  • Perform data profiling, cleansing, and validation to ensure data quality
  • Monitor and troubleshoot database performance, availability, and security
  • Work with development teams to integrate databases with applications
  • Document database designs, data dictionaries, and processes

Requirements

  • 5+ years of strong hands-on work experience with relational databases (e.g., DB2, PostgreSQL)
  • Proficiency in SQL and database programming (e.g., stored procedures, triggers)
  • Expertise in data modelling tools (e.g., ERwin, PowerDesigner, or similar)
  • Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) is preferrable
  • Strong understanding of normalization, de-normalization, and database design principles
  • Experience with performance tuning and query optimization
  • Knowledge of data warehousing concepts and star schema design
  • Understanding and implementing job schedules, dependencies, and workflows (e.g. Autosys)
  • Excellent problem-solving and communication skills

Benefits

  • Comprehensive employee benefits and perks
  • Flexible work arrangements

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

ETLInformaticaPostgresSQLSSIS

Location requirements

HybridMontrealCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.