Good hands-on years of experience in designing, building, and maintaining robust data pipelines using Python and SQL.
Expert in writing complex SQLs
Develop reusable scripts for data extraction from various structured and semi-structured file formats.
Write optimized and scalable queries to retrieve, clean, and transform data for analytics and reporting.
Integrate data from different sources, including APIs and multiple databases.
Work closely with analysts, data scientists, and business stakeholders to deliver clean, reliable datasets for analysis.
Document data workflows and ensure best practices in coding and version control.
Good to have experience on Paginated Reports and Power BI issues, Power BI Development, enhancement, and Migration.
Core Python: Expert-level proficiency in writing efficient, modular, and production-grade Python code for data extraction, transformation, and loading (ETL) processes.
SQL & Databases: Highly skilled in writing complex SQL queries, stored procedures, and optimizing database interactions. Hands-on experience connecting Python scripts with various relational databases (e.g., PostgreSQL, MySQL, SQL Server).
Data Source Integration: Extensive experience working with diverse file-based data sources such as CSV, JSON, and Excel, including parsing, transforming, and integrating them into ETL pipelines.
API & DB Connectivity: Exposure to consuming REST APIs for data ingestion and integrating multiple database sources in a unified workflow