Solution Architect

Location: Brampton, ON, ca

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.