Solution Architect

Posted 2 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

Magna International Logo Magna International

Architect

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
4 Locations
171000 Employees

Ericsson Logo Ericsson

Architect

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
2 Locations
88000 Employees

Aviva plc Logo Aviva plc

Architect

Insurance • Financial Services
In-Office
Markham, ON, CAN
36000 Employees
140K-190K Annually

Aviso Logo Aviso

Architect

Fintech • Payments • Financial Services
In-Office
Toronto, ON, CAN
1089 Employees
150K-168K Annually

Similar Companies Hiring

Legora Thumbnail
Artificial Intelligence • Legal Tech • Software
Chicago, Illinois
700 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account