Tata Consultancy Services

Maestro Data Architect

Tata Consultancy Services$130K — $150K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data engineering or data warehousing
  • Strong proficiency in SQL/PLSQL for data manipulation
  • Hands-on experience with Snowflake for ETL/ELT processes
  • Familiarity with AWS cloud services for database management
  • Experience with data modeling techniques including micro partitioning
  • Background in structuring data ingestion workflows from diverse sources
  • Ability to monitor and troubleshoot data pipelines effectively

Responsibilities

  • Design and develop robust ETL/ELT pipelines utilizing Snowflake and Python
  • Optimize data models for enhanced performance and efficiency
  • Implement business requirements using advanced Snowflake features
  • Collaborate with cross-functional teams to foster scalable solutions
  • Monitor pipeline operations to ensure data integrity and quality
  • Document data transformation processes for future reference and clarity

Benefits

  • Discretionary annual incentive based on performance
  • Comprehensive medical coverage including health, dental, and vision
  • Generous family support policies including maternal and parental leave
  • Diverse insurance options including auto, home, and identity theft protection
  • Professional growth opportunities with certification reimbursement
  • Flexible time off policies including vacation and sick leave
  • Access to legal assistance and student loan refinancing programs
Full Job Description
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: $130,000 - $150,000 a year

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry

Similar Jobs

  • Cognizant
    ASM Lead
    $70K — $132K *
    Cognizant
    Stamford, CT 06902 (Western Ct County)
  • Data Engineer
    $90K — $130K *
    Cortina Solutions
    Washington, DC 20011 (District Of Columbia County)
  • Data Center Engineer
    $73K — $132K *
    Leidos
    Bethesda, MD 20817 (Montgomery County)
  • Databrick Engineer
    $77K — $176K *
    Booz Allen Hamilton, Inc.
    Fort George G Meade, MD 20755 (Anne Arundel County)
  • Cushman & Wakefield
    Data Engineer
    $114K — $135K *
    Cushman & Wakefield
    Washington, DC 20011 (District Of Columbia County)
  • Cushman & Wakefield
    Data Engineer
    $114K — $135K *
    Cushman & Wakefield
    Boston, MA 02115 (Suffolk County)

More Jobs at Tata Consultancy Services

More Information Technology Jobs

Find similar Maestro Data Architect jobs: