Your browser does not support javascript! Please enable it, otherwise web will not work for you.

AWS Data Architect @ Tata Consultancy

Home > DBA / Data warehousing

 AWS Data Architect

Job Description

Role & responsibilities

  • Relational SQL/ Caching expertise Deep knowledge of Amazon Aurora PostgreSQL, ElastiCache etc..
  • Data modeling Experience in OLTP and OLAP schemas, normalization, denormalization, indexing, and partitioning.
  • Schema design & migration Defining best practices for schema evolution when migrating from SQL Server to PostgreSQL.
  • Data governance Designing data lifecycle policies, archival strategies, and regulatory compliance frameworks.
  • AWS Glue & AWS DMS Leading data migration strategies to Aurora PostgreSQL.
  • ETL & Data Pipelines Expertise in Extract, Transform, Load (ETL) workflows . Glue jobs features and event-driven architectures.
  • Data transformation & mapping PostgreSQL PL/pgSQL migration / transformation expertise while ensuring data integrity.
  • Cross-platform data integration Connecting cloud and on-premises / other cloud data sources.
  • AWS Data Services Strong experience in S3, Glue, Lambda, Redshift, Athena, and Kinesis.
  • Infrastructure as Code (IaC) Using Terraform, CloudFormation, or AWS CDK for database provisioning.
  • Security & Compliance Implementing IAM, encryption (AWS KMS), access control policies, and compliance frameworks (eg. GDPR ,PII).
  • Query tuning & indexing strategies Optimizing queries for high performance.
  • Capacity planning & scaling Ensuring high availability, failover mechanisms, and auto-scaling strategies.

Preferred candidate profile

  • Data Warehousing Expertise in Amazon Redshift, Snowflake, or BigQuery.
  • Big Data Processing Familiarity with Apache Spark, EMR, Hadoop, or Kinesis.
  • Data Lakes & Analytics Experience in AWS Lake Formation, Glue Catalog, and Athena.
  • Machine Learning Pipelines Understanding of SageMaker, BedRock etc. for AI-driven analytics.
  • CI/CD for Data Pipelines Knowledge of AWS CodePipeline, Jenkins, or GitHub Actions.
  • Serverless Data Architectures Experience with event-driven systems (SNS, SQS, Step Functions).

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time

Contact Details:

Company: Tata Consultancy
Location(s): Hyderabad

+ View Contactajax loader


Keyskills:   Data Architecture ETL AWS Terraform Data Warehousing

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Guidewire Datahub/infocenter Developer - Dhic

  • Zensar
  • 6 - 9 years
  • Pune
  • 3 days ago
₹ Not Disclosed

Data Architect

  • Addrec Solutions
  • 10 - 15 years
  • Bengaluru
  • 3 days ago
₹ Not Disclosed

Data Architect Data

  • Happiest Minds
  • 10 - 13 years
  • Bengaluru
  • 3 days ago
₹ Not Disclosed

Data Architect

  • Accenture
  • 3 - 8 years
  • Bengaluru
  • 4 days ago
₹ Not Disclosed

Tata Consultancy

We are hiring Fulltime with TechMahindra for below mentioned Skills:\\\\n\\\\n1. Experience with Big Data Environment\\\\n\\\\n2. Hands on coding in Python, Spark, Hive\\\\n\\\\n3. Shell Scripting