23 days ago
Toronto, CanadaSenior
Responsibilities
- Design, develop, and maintain scalable ETL/ELT processes and data pipelines using Informatica IDMC.
- Build and optimize data transformation workflows for efficient processing, reliable integration, and consistent data quality.
- Develop pipelines that extract, transform, and load data from multiple sources into cloud-based and enterprise data environments.
- Translate business requirements into technical designs and data engineering solutions with architects, analysts, stakeholders, and technology teams.
- Troubleshoot integration issues, optimize pipeline performance, and implement testing, monitoring, and data validation processes.
Requirements
- Typically 5–6 years of experience in data engineering, ETL development, or data integration, with experience delivering enterprise data solutions.
- Hands-on experience developing, configuring, and maintaining Informatica IDMC data integration workflows and pipelines.
- Strong understanding of ETL/ELT, data transformation, data mapping, and end-to-end data pipeline development.
- Proficiency in SQL, relational databases, query optimization, and complex data transformations.
- Experience collaborating with cross-functional teams to design, implement, test, and support scalable data engineering solutions.
- Experience with DevOps practices, CI/CD pipelines, version control, automated testing, and deployment processes is preferred.
- Familiarity with AWS, Azure, or Google Cloud and associated data services is preferred.
- Experience with Python, scripting, or automation for data engineering and pipeline orchestration is preferred.
- Understanding of data governance, data quality, and data lineage principles is preferred.
- Financial services experience in banking, capital markets, or related environments is preferred.
Benefits
- 100% company-paid health, life, and disability insurance effective from Day 1 of employment.
- Registered Retirement Savings Plan with the option for an employer matching contribution.
- Company-paid virtual health care for employees and their dependents or partners.
- Company-paid Employee and Family Assistance Program.
- Enhanced parental leave top-up benefits available from Day 1 of employment.
- Company-sponsored new parent gift.
- Fitness reimbursement benefit.
- Personalized one-on-one business coaching from Day 1.
- Continuous learning, training, and industry certification opportunities.
- Position based in Toronto; no remote or hybrid arrangement is stated.
About Capco
Capco is a global technology and management consultancy focused on financial services, helping banks, capital markets, insurance, and wealth firms with digital transformation, risk and compliance, and data/AI-enabled modernization. Founded in 1998 and headquartered in London, it operates as a Wipro company. Its business model centers on project-based consulting, managed services, and solution delivery across strategy, engineering, and platforms for regulated institutions.