AWS Data Architect
- Tata Consultancy
- 9 - 12 years
- Hyderabad
- 6 days ago
- Email to a friend
- Report this job
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.
- Data partitioning & storage optimization Designing cost-efficient hot/cold data storage policies.
- Should have experience with setting up the AWS architecture as per the project requirements
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 & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full timeContact Details:
Company: Tata ConsultancyLocation(s): Hyderabad+ View Contact
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Tata Consultancy
\n\nMavlers is a full-service digital marketing agency that has propelled growth for over 7,000 brands and agencies worldwide. As Google, Mailchimp, WP VIP, Microsoft, Salesforce, and HubSpot partners, we possess the expertise to deliver high-impact projects and campaigns tailored to our clients uni...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in