Senior Technical Analyst (Informatica)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Location: Flexible hybrid schedule with remote and in-office options; work location at 483 Bay Street, Toronto until approximately late 2026, then 3 Robert Speck Parkway, Mississauga. Current work authorization for Canada is required.
Annual total cash compensation, including base salary and target bonus: $123,000–$152,000 CAD.
Company
provides investment portfolios and services to Canadian individual and institutional investors and supports data, CRM, and business intelligence applications.
What you will do
- Develop and support ETL data integration solutions using Informatica IICS, Power Center, Snowflake SQL, and Oracle PL/SQL.
- Analyze business requirements and design technical solutions across source and target systems including Oracle, Snowflake, Salesforce, APIs, and flat files.
- Create mappings, mapplets, workflows, worklets, stored procedures, and optimized SQL code.
- Administer Informatica platforms and support application availability, maintenance, incidents, enhancements, and on-call operations.
- Execute unit tests, validate data integrity and performance, and manage emergency production fixes and deployments.
- Lead data initiatives, mentor developers, maintain technical documentation and data models, and participate in design and code reviews.
Requirements
- University degree, preferably in Computer Science, or equivalent work experience.
- 7+ years of ETL development experience with Informatica Power Center or IDMC.
- 2+ years of experience with iPaaS/IDMC and CDI.
- 5+ years of SQL and PL/SQL development experience and 5+ years of Oracle database development.
- 2+ years of experience in a Snowflake data warehouse environment.
- 1+ year of AWS experience.
- Experience with a data modelling tool.
- Current work authorization for Canada is required.
Nice to have
- Development experience in the mutual funds industry.
- Strong technical and data analysis skills.
- Excellent problem-solving skills.
- Customer service orientation.
Culture & Benefits
- Flexible working arrangements, including remote, hybrid, and in-office options.
- Competitive compensation with discretionary performance bonus and company RRSP contribution after six months.
- Employer-paid health benefits from the first day, including up to $5,000 annually for mental health services and therapy.
- Parental leave top-up to 100% of salary for 25 weeks and up to $650 for home office equipment.
- Paid time off, including two paid volunteer days annually, plus professional development, training courses, tuition reimbursement, and designation rewards.
- Inclusive, people-centric workplace with diversity programs and employee resource groups.
Hiring process
- Applications may be supported by AI-enabled LinkedIn Hiring Assistant and an AI screening tool; recruiters review and finalize hiring decisions.
- Accommodation is available on request during the selection process; only selected candidates will be contacted.
- No telephone inquiries or agency submissions.
Будьте осторожны
Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →