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.