Aws Data Engineer (Immediate Joiners Only)

Job description

• Strong 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 fast-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 strong 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.