Job Description
<p><p><b>About the Role :</b><br/><br/><b>Work Mode :</b> Hybrid<br/><br/><b>Notice Period :</b> (Immediate Joiner - Only)<br/><br/><b>Job Summary :</b></p><p><br/>- 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.</p><p><br/>- 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.</p><p><br/>- You will collaborate with cross-functional teams to build and maintain data-driven systems that power business insights and operational efficiency.</p><br/><p><b>Key Responsibilities :</b></p><p><br/>- Design, develop, and maintain robust Python-based applications and data pipelines to support business requirements.<br/><br/></p><p>- Write complex, optimized SQL queries to extract, transform, and load (ETL/ELT) data within Snowflake and other database systems.<br/><br/></p><p>- Architect and implement scalable data solutions using Snowflakes cloud data platform, including data modelling, performance tuning, and security best practices.<br/><br/></p><p>- Collaborate with data engineers, analysts, and stakeholders to understand requirements and deliver high-quality data solutions.<br/><br/></p><p>- Optimize Snowflake queries and workflows for performance, cost-efficiency, and scalability.<br/><br/></p><p>- Develop and maintain automated scripts and workflows using Python for data processing, integration, and orchestration.<br/><br/></p><p>- Ensure data integrity, quality, and security across all processes and systems.<br/><br/></p><p>- Troubleshoot and resolve issues related to data pipelines, database performance, and application functionality.<br/><br/></p><p>- Stay updated on industry trends and emerging technologies to recommend improvements and :</b></p><p><br/>- Bachelors degree in Computer Science, Engineering, or a related field (or equivalent experience).<br/><br/></p><p>- 5+ years of professional experience in software development with a <b>focus on Python and SQL programming</b>.<br/><br/></p><p>- 1+ years of hands-on experience with <b>Snowflake</b>, including data warehousing, query optimization, and <b>Snowflake-specific features (e.g., Snowpipe, tasks, streams).</b><br/><br/></p><p>- Strong proficiency in writing efficient, complex <b>SQL queries</b> and stored procedures.<br/><br/></p><p>- <b>Expertise in Python programming for data processing, scripting, and automation (e.g., pandas, NumPy, or similar libraries).</b><br/><br/></p><p>- <b>Experience with ETL/ELT processes and tools (e.g., Apache Airflow, dbt, or similar).</b><br/><br/></p><p>- Familiarity with cloud platforms (e.g., AWS, Azure, or GCP) and their integration with Snowflake.<br/><br/></p><p>- Knowledge of data modeling, database design, and performance tuning.<br/><br/></p><p>- Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment.<br/><br/></p><p>- Strong communication skills to articulate technical concepts to non-technical stakeholders.</p><br/><p><b>Preferred Skills :</b></p><p><br/>- Experience with version control systems (e.g., Git) and CI/CD pipelines.<br/><br/></p><p>- Familiarity with other big data technologies (e.g., Spark, Hadoop, or Kafka).<br/><br/></p><p>- Knowledge of data visualization tools (e.g., Tableau, Power BI) or reporting frameworks.<br/><br/></p><p>- Certification in Snowflake (e.g., SnowPro Core) or related cloud technologies is a huge plus.<br/><br/></p><p>- Understanding of DevOps practices and tools for deployment and monitoring.</p><br/></p> (ref:hirist.tech)