Solution Architect

Reposted 20 Days Ago
Be an Early Applicant
Brampton, ON, CAN
In-Office
Senior level
Artificial Intelligence • Cloud • Information Technology • Professional Services
The Role
Architect and design BI/ETL solutions on the BI platform using Informatica PowerCenter. Lead development teams, define ETL architecture, ensure data quality, resolve data integrity issues, perform QA, and collaborate with vendors and product teams.
Summary Generated by Built In
Company Description

Continental Technology Solutions is Our consulting and managed services deliver the resources and capabilities required to assess,design, build and manage an agile, flexible IT environment. You'll work with one dedicated team from strategy and assessment through design, implementation, management and optimisation to reach a true end-to-end solution.

Job Description

Role and Responsibilities
ü Understand customer's business requirements and technical environment to architect the optimal solution
ü Design solutions on the BI Platform leveraging design patterns (standards & solution specific)
ü Collaborate with the different product vendors/app groups while designing the interfaces with 3rd party services, backend systems and various analytical tools
ü Lead the development team in delivering the solution
ü Perform quality assurance on deliverables and work products
ü Audit, uncover and resolve data integrity issues
ü Recommend best practices
Skills:
ü Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1 PowerCenter Client tools.
ü Adept at handling the international clients, Experienced in Offshore-Onsite Delivery Model and Production Support. Experience of leading team of developers.
ü In depth knowledge of dimensional Modeling and Data warehouse concepts like Star, snowflake schemas, facts, dimensions, logical and physical data modeling
ü Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
ü Lead and guide development of an Informatica based ETL architecture and Hands on experience in design , development, ETL testing of ETL Process and data quality process.

Skills Required

  • Strong Data Warehousing and ETL experience using Informatica PowerCenter (9.1/8.6.1) and PowerCenter Client tools
  • Hands-on experience designing and developing ETL processes, ETL testing, and data quality processes
  • In-depth knowledge of dimensional modeling and data warehouse concepts (star, snowflake, facts, dimensions)
  • Experience leading development teams and providing technical leadership
  • Experience with offshore-onsite delivery model and production support for international clients
  • Ability to collaborate with product development teams and vendors to define architectural requirements
  • Ability to audit, uncover and resolve data integrity issues and recommend best practices
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
350 Employees

What We Do

Continental Technology Solutions is an Information Technology and Professional Services company headquartered in Houston, USA, with global offices in the UK, Canada, Australia, Singapore, Hong Kong, and India. The company specializes in AI, cloud technology, and Product Lifecycle Management (PLM), providing innovative business solutions and staffing services to a client list that includes mid-sized to Fortune 500 companies worldwide.

Similar Jobs

Onepoint Logo Onepoint

Architect

Software • Design
In-Office
Ottawa, ON, CAN
3518 Employees

Enbridge Logo Enbridge

Architect

Energy • Renewable Energy
In-Office
North York, ON, CAN
10753 Employees
130K-149K Annually

Cloud SynApps Inc. Logo Cloud SynApps Inc.

Architect

Cloud • Information Technology • Database
In-Office
Mississauga, ON, CAN
120 Employees

Manulife Logo Manulife

Architect

Fintech • Insurance • Financial Services
In-Office
Toronto, ON, CAN
32427 Employees
113K-210K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account