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

Database Administrator (MySQL & AWS)

  • Luxoft
  • 6 - 11 years
  • Pune
  • 2 days ago
₹ Not Disclosed

Database Lead

  • Idexcel
  • 8 - 13 years
  • Hyderabad
  • 2 days ago
₹ Not Disclosed

Database Engineer II

  • Zensar
  • 2 - 4 years
  • Pune
  • 2 days ago
₹ Not Disclosed

Oracle Exadata Architect - Mumbai Bangalore

  • Datamatics
  • 13 - 20 years
  • Mumbai
  • 2 days ago
₹ Not Disclosed

Tata Consultancy

Wipro Ltd (NYSE:WIT) is a global information technology, consulting and outsourcing company with 170,000+ workforce serving clients in 175+ cities across 6 continents. \\r\\n\\r\\nWipro helps customers do business better by leveraging our industry-wide experience, deep technology expertise, comprehe...