Maestro Data Architect

Tata Consultancy Services Limited
Stamford, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 150K

Job location

Stamford, United States of America

Tech stack

API
Amazon Web Services (AWS)
Cloud Computing
Databases
Data Architecture
ETL
Data Warehousing
Document-Oriented Databases
JSON
Job Scheduling
Python
Performance Tuning
Cloud Services
PL-SQL
SQL Databases
XML
Parquet
Data Ingestion
Snowflake
Information Technology

Job description

  • 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

Requirements

Do you have experience in Technical writing?, Do you have a Bachelor's degree?, * 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, Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

Pulled from the full job description

  • Pet insurance
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Commuter assistance, 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

Apply for this position