Solid hands-on experience with Amazon Redshift, including database design, query optimization, workload management, and performance tuning in large-scale data warehouse environments.
Minimum 3+ years of experience working with large-scale datasets, handling high-volume transactional and analytical data efficiently.
Expert-level proficiency in developing, debugging, and optimizing Stored Procedures in Amazon Redshift.
Strong expertise in writing high-performance SQL queries, including complex joins, CTEs, window functions, aggregations, and query optimization techniques.
Experience in performance tuning and troubleshooting slow-running SQL queries, ETL pipelines, and Redshift workloads.
Solid understanding of data warehousing concepts, dimensional modeling, star/snowflake schemas, and data transformation processes.
Experience working with ETL/ELT processes and integrating data from multiple heterogeneous data sources.
Ability to analyze business requirements and translate them into scalable and efficient SQL-based solutions.
Strong understanding of database best practices, indexing strategies, distribution keys, sort keys, partitioning,



and data compression techniques in Redshift.
Experience with data validation, reconciliation, and ensuring data quality and integrity across systems.
Ability to work effectively in quick-paced environments, manage tight deadlines, and consistently deliver high-quality, production-ready code.
Strong problem-solving and analytical skills with attention to detail and accuracy.
Experience collaborating with cross-functional teams including Data Engineers, Business Analysts, QA teams, and business stakeholders.
Knowledge of version control systems, deployment processes, and release management practices is preferred.
Familiarity with cloud-based data ecosystems and AWS services related to Redshift is an added advantage.
Must have solid domain knowledge in Pharma/Healthcare/Medical Claims data, including claims processing, adjudication, eligibility, provider/member data, ICD/CPT codes, and healthcare reporting requirements.
Excellent communication skills with the ability to explain technical solutions to both technical and non-technical stakeholders.

📌 Aws Data Engineer Immediate Joiners Only Telangana
🏢 Straive
📍 Telangana