Responsibilities 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. Basic understanding of AWS. Experience with orchestration/scheduling tool, preferably Tidal. Experience in Python is an advantage. Working experience on data warehousing and modeling. Basic understanding of banking terminology. Benefits Discretionary Annual Incentive. 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 BACHELOR OF COMPUTER SCIENCE #J-18808-Ljbffr
Technical Architect
TATA CONSULTANCY SERVICES
, , canada, , , canada
Published 27 days ago
Report job