Python, SQL

Skill: Python, SQL

Experience: 6 to 9 Years

Location : AIA – Kolkata

Job Summary

We are seeking a skilled Python Developer with strong SQL knowledge to design, develop, and maintain data-driven applications. The ideal candidate will work closely with cross-functional teams to build scalable, efficient, and secure systems for data processing, analytics, and automation.

Key Responsibilities

• Design, develop, and maintain Python applications for data processing and automation.
• Write optimized SQL queries, stored procedures, and database scripts for relational databases (e.g., MySQL, PostgreSQL, SQL Server).
• Integrate Python applications with databases and APIs for data ingestion and transformation.
• Optimize database performance, indexing, and query execution plans.
• Collaborate with data analysts, engineers, and product teams to deliver business solutions.
• Implement ETL (Extract, Transform, Load) pipelines for data migration and reporting.
• Ensure code quality through unit testing, code reviews, and adherence to best practices.
• Maintain documentation for code, database schemas, and workflows.
• Troubleshoot and debug application and database issues.

Required Skills & Qualifications

• Strong proficiency in Python (Pandas, NumPy, SQLAlchemy, etc.).
• Solid understanding of SQL (DDL, DML, joins, subqueries, indexing, transactions).
• Experience with relational databases such as PostgreSQL, MySQL, or SQL Server.
• Knowledge of database design, normalization, and performance tuning.
• Familiarity with version control systems (Git).
• Experience with REST APIs and JSON/XML data formats.
• Strong problem-solving and analytical skills.

Preferred Skills

• Experience with cloud platforms (AWS, Azure, GCP).
• Knowledge of NoSQL databases (MongoDB, Redis).
• Familiarity with data visualization tools (Tableau, Power BI, Matplotlib, Seaborn).
• Understanding of CI/CD pipelines and containerization (Docker).
• Experience with big data tools (Spark, Hadoop) is a plus.