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

- Solid 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.

📌 Data Engineer (Telangana)
🏢 Anblicks Solutions
📍 Telangana