Data Engineer

Role & responsibilities Design, develop, and maintain scalable data pipelines using Python and SQL. Develop and optimize ETL/ELT processes to ingest, transform, and load data from multiple sources. Write complex SQL queries and optimize them for performance. Design and maintain data models, database schemas, and data warehouses. Perform data validation, cleansing, and quality checks. Optimize database performance through indexing, partitioning, and query tuning. Work with structured and semi-structured data from multiple data sources. Collaborate with business stakeholders, data analysts, and engineering teams to understand data requirements. Troubleshoot production issues and ensure data reliability and integrity. Follow coding standards, perform code reviews, and maintain technical documentation. Required Technical Skills Python Strong programming skills in Python. Object-Oriented Programming (OOP). Data processing using Pandas and NumPy. File handling (CSV, JSON, XML, Parquet). Exception handling and logging. REST API integration. Writing reusable and scalable Python code. Experience with virtual environments and package management. SQL (Advanced) Expert in writing complex SQL queries. Joins, Subqueries, and Correlated Subqueries. Common Table Expressions (CTEs). Window (Analytical) Functions. Recursive Queries. Stored Procedures, Functions, and Triggers. Indexing, Partitioning, and Query Optimization. Execution Plan Analysis and Performance Tuning. Transactions and ACID properties. Normalization and Denormalization. Views and Materialized Views. Data Modeling and Schema Design Note-Looking for Immediate to 10 days notice candidates.