Data Architect AWS Redshift

3 days ago

Hyderabad, Telangana, India Twinpacs Full time ₹ 10,000 - ₹ 50,000 per year

This is an exclusive job role - 100% Remote - India & EST hours - extended hours.

Data Architect (AWS Redshift) || 10-15 Y || EST Hours || 100% Remote (Hyderabad) || 6M Contract ||

Prefer Locals, F2F Required - Final Round @ Hyderabad Office

Interview Process: 2 Technical Sessions + 1 Client Session + 1 F2F - Managerial Round (MUST)

Job Role:

Design, develop, test, deploy and troubleshoot SQL scripts, Stored Procedures that implement complex PLSQL solutions.

Must have experience in Query Optimization.

Must be able to understand complex business logic, fine tune long-running queries

Must be expert at reverse engineering and extracting business requirements and rules from the code.

Scheduling and monitoring the ETL jobs using SSIS.

Build and review functional and business specifications

Expert understanding of PostgreSQL, Stored Procedures, Views, and Functions.

Provide the estimates for the ETL work

Database/Data Warehouse performance tuning, monitoring and troubleshooting expertise.

Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tables

Troubleshooting and fixing the code

Unit testing the code and documentation of results

Must be expert at providing non-functional requirements.

Help creating test data and provide support to QA process.

Work with gate keeper on promoting the data stage jobs from QA to Production.

Build, patch and data fix in production environment.

Ensure very high availability to scale of 99.999%.

Establish coding practices, best practices, and SoPs. Participate in code reviews and enforce relevant process.

Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customers

Ability to perform independent research to understand the product requirements and customer needs

Communicates effectively with the project teams and other stakeholders. Translate technical details to non-technical audience.

Expert at creating architectural artifacts for Data Warehouse.

Team, effort management.

Ability to set expectations for the client and the team. Ensure all deliverables are delivered in time at highest quality.

Required Skills:

ETL-SSIS

SQL

Stored Procedure, Functions, Triggers etc

Query Optimization

Server monitoring

ETL: -AWS-Glue

DBMS: AWS Aurora MySQL, AWS Redshift, PostgreSQL

Cloud Services: -AWS cloud services, including EC2, RDS, S3, and IAM.

Data Skills: - SQL Performance tuning.

Coding: - knowledge of programming language like C#, Python or Java. To oversee dev resources.

  • Team and people management.
  • Agile scrum practices
  • Great learning attitude
  • Eagerness to take ownership
  • A global mindset
  • Excellent communication skills.

  • AWS Solution Architect

    3 days ago

    Hyderabad, Telangana, India People's Growth HR Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title: AWS Solution ArchitectLocation: Hyderabad/Bangalore/RemoteExperience: 14+ Years14+ years of experience in IT, with at least 4+ years in solution architecture roles.10+ years of experience designing and deploying applications on AWS cloud platforms.Strong knowledge of AWS services (EC2, S3, Lambda, RDS, Redshift, DynamoDB, ECS, EKS, API Gateway,...

  • AWS-Redshift Database Administrator

    5 hours ago

    Hyderabad, Telangana, India, Telangana Tata Consultancy Services Full time

    Greetings!!!TCS is hiringRole: AWS-Redshift Database AdministratorEXP: 6- 8 YEARSLOCATION: Bengaluru/ Hyderabad/ Pune/ Bhubaneshwar/ Chennai/ KochiDesired Skills -Must-HaveGood in designing, implementing, performance tuning and maintaining database systems by analyzing needs of customers and maintaining the database clusters to ensure accurate...

  • AWS Data Engineer

    1 week ago

    Hyderabad, Telangana, India Uplers Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Experience: yearsSalary: Confidential (based on experience)Expected Notice Period: 7 DaysShift: (GMT+05:30) Asia/Kolkata (IST)Opportunity Type: Hybrid (Hyderabad)Placement Type: Full Time Permanent position(Payroll and Compliance to be managed by: Clovertex)**(*Note: This is a requirement for one of Uplers' client - Clovertex)**What do you need for this...

  • Aws Solution Architect

    1 week ago

    Hyderabad, Telangana, India People Tech Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role OverviewPeople Tech Group is seeking a seasoned Solution Architect with deep expertise in AWS and Generative AI to lead the design and delivery of advanced AI systems for enterprise clients. This includes agentic applications, NLSQL interfaces, and RAG-based search solutions.Role & responsibilitiesArchitect GenAI Workloads: Lead end-to-end design and...

  • AWS Data Engineer

    4 days ago

    Hyderabad, Telangana, India People Prime Worldwide Full time ₹ 15,00,000 - ₹ 35,00,000 per year

    Important Note (Please Read Before Applying)DoNOT applyif:You have less than 6 years or more than 17 years of experienceYou do not have hands-on AWS Data Engineer 5+ experienceYou are on a notice period longer than 15 daysYou are looking for remote onlyYou are a fresher or unrelated background (e.g., support, testing only, non-Java roles) ApplyONLY...

  • Data Architect

    1 week ago

    Hyderabad, Telangana, India Amzur Technologies Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Data ArchitectJob Description:We are looking for a highly skilled Data Architect with over 10 years of experience in designing,implementing, and managing large-scale data architecture solutions. The ideal candidate will havedeep expertise in data modeling, cloud data platforms (Azure/AWS), and data governance, with aproven ability to architect secure,...

  • Data Engineer AWS

    2 weeks ago

    Hyderabad, Telangana, India Click Objects Information Systems Private Limited Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are looking for Data Engineer for the below requirement.Key Responsibilities:● Collaborate with cloud engineer to migrate and execute AWS DMS replication tasks.● Migrate data in data warehouses across AWS accounts.● Migrate IICS task flows and repoint them in the new AWS account.● Manage and re-deploy Python and Lambda functions.● Migrate ECS...

  • AWS Data Engineer

    6 days ago

    Hyderabad, Telangana, India Talent Worx Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Senior AWS Data EngineerOverview:We are seeking experienced AWS Data Engineers to design, implement, and maintain robust data pipelines and analytics solutions using AWS services. The ideal candidate will have a strong background in AWS data services, big data technologies, and programming languages.Exp- 3 to 7 years Location- Bangalore, Pune, Hyderabad,...

  • Data Architect – Cloud Data

    1 day ago

    Hyderabad, Telangana, India Experian Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Company Description Experian is a global data and technology company, powering opportunities for people and businesses around the world. We help to redefine lending practices, uncover and prevent fraud, simplify healthcare, create marketing solutions, and gain deeper insights into the automotive market, all using our unique combination of data, analytics and...

  • Aws Data Engineer

    2 weeks ago

    Hyderabad, Telangana, India Quess Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role & responsibilities:Design, deploy, and manage cloud-native solutions using AWS services such as Glue, Lambda, S3, DynamoDB, Lake Formation, Athena, Redshift, and RDS.Build scalable data lakes using S3 and Iceberg, ensuring secure and governed access to data for analytics and reportingImplement event-driven workflows using Lambda, SNS, and EventBridge...