Data Engineer - Python, AWS, SQL

We're seeking a skilled Mid-Level Data Engineer to join our team at SMC Global SecuritiesExperience : 4- 8 yearsNotice Period : Immediate, 1 monthJob Location : Delhi (On-site)Key Skills Required :- Design, build, and maintain highly efficient and scalable real-time & batch data pipelines- Implement and enforce data modeling standards- Build data pipelines using a Medallion Architecture, progressing data through Bronze, Silver and Gold- Develop and optimize composable data architectures and data transformation processes- Manage and maintain data storage solutions across our Data Lake (S3), Data Warehouse- Write and optimize complex SQL queries and Python scripts- Implement and orchestrate data workflows.Good to Have (Not Mandatory) :- Exposure to DBT (Data Build Tool)- Experience with reporting tools, preferably MetabaseWe are Looking for Someone Who :- Strong proficiency in SQL and Python- Good understanding of data modeling concepts- Strong understanding of Medallion and composable data architectures.- Solid understanding of data architecture concepts including Data Lake, Data Warehouse, and Data Lakehouse.- Hands-on experience with AWS cloud services, including but not limited to S3, Redshift, Athena, Glue, EMR, and Lambda.- Experience with open-source data tools like Airflow, DBT, and Airbyt.- Familiarity with Hive & Iceberg tables is essential. (ref:hirist.tech) .