Job Location: First Floor, Wing B, North Gate [Phase I], SEZ, Sy. No.2/1, 2/2, Venkatala Village, Yelahanka Hobli, Bengaluru, Karnataka, 560064
Mode of Work: Hybrid, 3 days a week
Transport: No
Employment Type: Full-Time
Experience Level: Senior (5-8 years)
Notice Period: Immediate - 7 days
R2 will be F2F, please inform the candidates earlier itself.
Job Summary:
We are looking for a highly skilled Senior Python and SQL Developer with over 5 years of experience in designing, developing, and optimizing complex data pipelines and applications.
The ideal candidate will have at least 1-2 years of hands-on experience with Snowflake, strong proficiency in Python and SQL, and a proven record of accomplishment in delivering scalable, high-performance solutions.
You will collaborate with cross-functional teams to build and maintain data-driven systems that power business insights and operational efficiency.
Key Responsibilities:
- Design, develop, and maintain robust Python-based applications and data pipelines to support business requirements.
- Write complex, optimized SQL queries to extract, transform, and load (ETL/ELT) data within Snowflake and other database systems.
- Architect and implement scalable data solutions using Snowflake’s cloud data platform, including data modelling, performance tuning, and security best practices.
- Collaborate with data engineers, analysts, and stakeholders to understand requirements and deliver high-quality data solutions.
- Optimize Snowflake queries and workflows for performance, cost-efficiency, and scalability.
- Develop and maintain automated scripts and workflows using Python for data processing, integration, and orchestration.
- Ensure data integrity, quality, and security across all processes and systems.
- Troubleshoot and resolve issues related to data pipelines, database performance, and application functionality.
- Stay updated on industry trends and emerging technologies to recommend improvements and innovations.
Qualifications:
- Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience).
- 5+ years of professional experience in software development with a focus on Python and SQL programming.
- 1+ years of hands-on experience with Snowflake, including data warehousing, query optimization, and Snowflake-specific features (e.g., Snowpipe, tasks, streams).
- Strong proficiency in writing efficient, complex SQL queries and stored procedures.
- Expertise in Python programming for data processing, scripting, and automation (e.g., pandas, NumPy, or similar libraries).
- Experience with ETL/ELT processes and tools (e.g., Apache Airflow, dbt, or similar).
- Familiarity with cloud platforms (e.g., AWS, Azure, or GCP) and their integration with Snowflake.
- Knowledge of data modeling, database design, and performance tuning.
- Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment.
- Strong communication skills to articulate technical concepts to non-technical stakeholders.
Preferred Skills:
- Experience with version control systems (e.g., Git) and CI/CD pipelines.
- Familiarity with other big data technologies (e.g., Spark, Hadoop, or Kafka).
- Knowledge of data visualization tools (e.g., Tableau, Power BI) or reporting frameworks.
- Certification in Snowflake (e.g., SnowPro Core) or related cloud technologies is a huge plus.
- Understanding of DevOps practices and tools for deployment and monitoring.