Python SQL Developer

We are looking for a skilled Python Developer with hands-on experience in building and consuming API's, designing database schemas, and integrating data pipelines that support visualization in Tableau. The ideal candidate will have a strong foundation in Python development, database design and API integration, with an added advantage of working knowledge of Tableau for data visualization.

Key Responsibilities

• API Development & Integration

o Design, develop, and maintain RESTful APIs using Python frameworks (e.g., FastAPI, Flask, or Django).

o Consume third-party APIs and integrate them with internal systems.

o Optimize data storage and retrieval mechanisms for performance and scalability.

o Ensure API performance, security, and scalability.

o Implement data validation and quality checks to ensure accuracy and consistency

• Database Modeling & Architecture

o Design and implement relational database schemas (PostgreSQL, MySQL, or similar).

o Write optimized SQL queries, stored procedures, and triggers.

o Evaluate and implement data storage solutions, including relational databases, NoSQL databases, data lakes, and cloud storage services.

o Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.

o Manage ETL (Extract, Transform, Load) processes to store and prepare data for analytics.

• Data Deployment & Visualization

o Deploy API data into structured databases.

o Prepare datasets for visualization in Tableau.

o Collaborate with data analysts/BI teams to ensure smooth integration between data and Tableau dashboards.

• Collaboration & Best Practices

o Work with cross-functional teams (Data, DevOps, BI) to deliver endt-to-end solutions.

o Follow coding standards, version control (Git), and CI/CD pipelines.

o Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field. Master's degree preferred.

• Proficiency in programming languages commonly used in data engineering (e.g., Python, Java, Scala, etc.).

• Strong knowledge of Python programming and frameworks for API development.

• Experience in API consumption and integration.

• Hands-on experience in relational databases (PostgreSQL, MySQL, or similar) including schema design and query optimization.

• Understanding of ETL processes and data pipeline development.

• Familiarity with deployment best practices and Git-based workflows.

Good to Have

• Basic experience with Tableau (creating simple dashboards or understanding Tableau data sources).

• Exposure to cloud platforms (AWS, GCP, or Azure).

• Knowledge of containerization (Docker, Kubernetes).

• Understanding of data security and API authentication standards (OAuth, JWT).

• Certification on any core product skills

Soft Skills

• Strong problem-solving ability and attention to detail.

• Excellent communication skills to work with both technical and non-technical stakeholders.

• Ability to work independently as well as part of collaborative team.

Job Type: Contractual / Temporary

Contract length: 06 months

Pay: ₹389, ₹2,070,428.38 per year

Experience:

• Total work: 3 years (Required)

Work Location: In person