Job Summary:
We are seeking a highly skilled Python + SQL Developer with 3-5 years of experience to join our team. The ideal candidate will have a solid foundation in Python programming, SQL development, and experience in working with large datasets, databases, and data processing tools. This position offers an exciting opportunity to work on cutting-edge data-driven applications, optimize database performance, and design scalable solutions for our growing business needs.
Key Responsibilities:
- Python Development:
- Write, test, and maintain high-quality Python code for data processing, automation, and application development.
- Develop Python-based applications for backend services, APIs, and automation processes.
- Collaborate with the team to implement RESTful APIs using Flask or Django frameworks.
- Write, test, and maintain high-quality Python code for data processing, automation, and application development.
- Develop Python-based applications for backend services, APIs, and automation processes.
- Collaborate with the team to implement RESTful APIs using Flask or Django frameworks.
- SQL Development:
- Write complex SQL queries, including joins, subqueries, and aggregate functions, for data extraction, manipulation, and reporting.
- Optimize SQL queries for performance, ensuring fast data retrieval even for large datasets.
- Create and manage stored procedures, views, and functions in databases such as MySQL, PostgreSQL, or SQL Server.
- Write complex SQL queries, including joins, subqueries, and aggregate functions, for data extraction, manipulation, and reporting.
- Optimize SQL queries for performance, ensuring fast data retrieval even for large datasets.
- Create and manage stored procedures, views, and functions in databases such as MySQL, PostgreSQL, or SQL Server.
- Data Integration & ETL:
- Design and implement ETL pipelines for extracting, transforming, and loading data from various sources into databases or data warehouses.
- Integrate data from external systems using APIs and SQL queries to support real-time data exchange and reporting.
- Design and implement ETL pipelines for extracting, transforming, and loading data from various sources into databases or data warehouses.
- Integrate data from external systems using APIs and SQL queries to support real-time data exchange and reporting.
- Database Management & Optimization:
- Work closely with the DBA team to ensure optimal database performance through index tuning, query optimization, and best practices.
- Design data models and schemas to ensure data consistency and integrity.
- Support the team in data migration and database scaling for high-performance systems.
- Work closely with the DBA team to ensure optimal database performance through index tuning, query optimization, and best practices.
- Design data models and schemas to ensure data consistency and integrity.
- Support the team in data migration and database scaling for high-performance systems.
- Collaboration & Documentation:
- Work alongside cross-functional teams, including data scientists, engineers, and product managers, to ensure seamless integration and performance.
- Prepare clear, concise technical documentation for databases, code, and processes.
- Participate in code reviews and ensure adherence to best practices.
- Work alongside cross-functional teams, including data scientists, engineers, and product managers, to ensure seamless integration and performance.
- Prepare clear, concise technical documentation for databases, code, and processes.
- Participate in code reviews and ensure adherence to best practices.
- Troubleshooting & Support:
- Identify and resolve bugs, data inconsistencies, and performance bottlenecks in production environments.
- Provide ongoing support for deployed solutions, ensuring minimal downtime and high system reliability.
- Identify and resolve bugs, data inconsistencies, and performance bottlenecks in production environments.
- Provide ongoing support for deployed solutions, ensuring minimal downtime and high system reliability.
Required Qualifications:
- Education:
- Bachelor's Degree in Computer Science, Information Technology, or related field.
- Bachelor's Degree in Computer Science, Information Technology, or related field.
- Professional Experience:
- 3-5 years of hands-on experience in Python development and SQL programming.
- Proven expertise in developing applications and solutions using Python (Flask, Django, Pandas, NumPy) and SQL (MySQL, PostgreSQL, SQL Server, Oracle).
- Strong experience in data manipulation, data modeling, and database optimization.
- Experience with API development (RESTful APIs) and integrating external systems.
- 3-5 years of hands-on experience in Python development and SQL programming.
- Proven expertise in developing applications and solutions using Python (Flask, Django, Pandas, NumPy) and SQL (MySQL, PostgreSQL, SQL Server, Oracle).
- Strong experience in data manipulation, data modeling, and database optimization.
- Experience with API development (RESTful APIs) and integrating external systems.
- Technical Skills:
- Python Programming: Strong understanding of Python libraries (e.g., Pandas, NumPy, Flask/Django).
- SQL Development: Advanced skills in writing optimized queries and managing relational databases.
- Database Management: Experience with MySQL, PostgreSQL, SQL Server, or similar RDBMS.
- Data Integration & ETL: Proficient in building ETL pipelines and data processing workflows.
- Version Control: Familiarity with Git, GitHub, or Bitbucket.
- Python Programming: Strong understanding of Python libraries (e.g., Pandas, NumPy, Flask/Django).
- SQL Development: Advanced skills in writing optimized queries and managing relational databases.
- Database Management: Experience with MySQL, PostgreSQL, SQL Server, or similar RDBMS.
- Data Integration & ETL: Proficient in building ETL pipelines and data processing workflows.
- Version Control: Familiarity with Git, GitHub, or Bitbucket.
- Soft Skills:
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration skills, with the ability to work in an agile environment.
- Ability to prioritize tasks, meet deadlines, and handle multiple projects concurrently.
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration skills, with the ability to work in an agile environment.
- Ability to prioritize tasks, meet deadlines, and handle multiple projects concurrently.
Preferred Qualifications:
- Experience with cloud platforms (AWS, Azure, GCP).
- Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).
- Exposure to data warehousing and big data technologies (e.g., Hadoop, Spark).
- Certifications in relevant technologies (AWS, Azure, SQL, Python).