Maestro Data Architect

Stamford, CT - USA

Monthly Salary: Not Disclosed

Posted on: 9 hours ago

Vacancies: 1 Vacancy

Job Summary

Must Have Technical/Functional Skills

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

Roles & Responsibilities

Hands-on experience with Cloud based Database preferably Snowflake

Excellent SQL / PL SQL skills

Basic understanding on AWS

Experience on orchestration / scheduling tool preferably Tidal

Experience on Python is an advantage

Working experience on Data Warehousing and Modeling

Basic understanding of Banking terminology

TCS Employee Benefits Summary:

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: $130000 - $150000 a year

Must Have Technical/Functional Skills 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....