Overview
Technical Architect Jobs in Chibougamau, Canada at Tata Consultancy Services
Title: Technical Architect
Company: Tata Consultancy Services
Location: Chibougamau, Canada
Category:
- Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services preferably AWS
- Build and optimize data models (staging, warehouse, Datamarts) using best practices such as micro partitioning, clustering, and performance tuning.
- Develop and manage data ingestion workflows from structured and semi‑structured sources (JSON, Parquet, XML, APIs, etc.).
- Implementation of business requirements using Snowflake features such as Streams, Tasks, Time Travel, Zero Copy Cloning, and Snowpipe for automated data loads.
- Collaborate with Data architects, analysts, and business stakeholders to translate requirements into scalable technical solutions.
- Monitor and troubleshoot pipelines for failures and issues ensuring data quality and integrity.
- Document data flows, transformations, and technical processes for maintainability and knowledge sharing.
- Excellent analytical skills and strong understanding of SQL/PLSQL.
- Job scheduling and orchestration using industry‑standard tools.
- Hands‑on experience with cloud‑based database, preferably Snowflake.
- Experience with orchestration/scheduling tool, preferably Tidal.
- Working experience on data warehousing and modeling.
- Basic understanding of banking terminology.
Benefits
- Comprehensive Medical Coverage:
Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. - Family Support:
Maternal & Parental Leaves. - Insurance Options:
Auto & Home Insurance, Identity Theft Protection. - Convenience & Professional Growth:
Commuter Benefits & Certification & Training Reimbursement. - Time Off:
Vacation, Time Off, Sick Leave & Holidays. - Legal & Financial Assistance:
Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. - Salary Range: $130,000 – $150,000 a year
Qualifications#J-18808-Ljbffr