Snowflake/ETL Expert with Python

Job Description Description Snowflake and Python ETL Expert 8+years Work Mode & Location Hybrid: 3 days from office Work Location: PAN India (GlobalLogic offices)Pune, Nagpur, Bangalore, Chennai, Hyderabad, Gr.Noida, Ahmedabad Preference: Immediate joiners Requirements We are looking for a highly skilled and 8+ years of experienced Snowflake and ETL Expert. The ideal candidate will be responsible for designing, developing, and managing our data warehouse on the Snowflake platform. He be a key player in ensuring our data infrastructure is efficient, scalable, and secure. Technical Skills: - Proficiency in SQL, with a deep understanding of advanced functions and query optimization. - Strong knowledge of Snowflake-specific features like Snowpipe, Time Travel, Zero-Copy Cloning, and Streams. - Experience with ETL/ELT tools (e.g., Fivetran, Informatica) and orchestration tools (e.g., Airflow). - Proficiency in a scripting language like Python. - Proficiency with cloud platforms (AWS, Azure, or GCP). Soft Skills: - Excellent problem-solving and analytical skills. - Strong communication and collaboration abilities. - Detail-oriented with a commitment to producing high-quality work Preferred Qualifications - Certifications: Snowflake Certified Advanced Administrator or Snowflake Certified Data Engineer. - Tools: Experience with data build tool (dbt) for data transformation. - Big Data: Knowledge of big data technologies (e.g., Hadoop, Spark). Strong communication and interpersonal skills, with the ability to interact directly and effectively with business stakeholders at all levels. Ability to work independently and collaboratively in a fast-paced environment. This role requires an on-site presence in Australia, so a visa is necessary. Education: Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field. Experience: Proven experience 8+ years working with data warehousing solutions, with at least 3-5 years of hands-on experience on the Snowflake Data Cloud. Job responsibilities Key Responsibilities - Design and Development: Lead the design and implementation of data warehousing solutions on Snowflake. This includes creating and optimizing schemas, tables, and views. - ETL/ELT Processes: Develop and manage complex ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) pipelines to ingest data from various sources into Snowflake. - Performance Tuning: Monitor, troubleshoot, and optimize query and data load performance. This includes fine-tuning virtual warehouses, optimizing SQL queries, and managing clustering keys. - Security and Governance: Implement and maintain data security policies, roles, and access controls within Snowflake. Ensure compliance with data governance standards. - Data Modeling: Collaborate with business stakeholders and data analysts to understand data requirements and translate them into effective data models. - Automation: Automate data pipelines and administrative tasks using scripting languages like Python or tools like dbt (data build tool). - Documentation: Create and maintain comprehensive documentation for all Snowflake-related processes, data models, and configurations - Strong communication and interpersonal skills, with the ability to interact directly and effectively with business stakeholders at all levels. - Ability to work independently and collaboratively in a fast-paced environment. - This role requires an on-site presence in Australia, so a visa is necessary. What we offer Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you'll experience an inclusive culture of acceptance and belonging, where you'll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders. Learning and development. We are committed to your continuous learning and development. You'll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally. Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you'll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what's possible and bring new solutions to market. In the process, you'll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today. Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you're placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do. About GlobalLogic GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world's largest and most forward-thinking companies. Since 2000, we've been at the forefront of the digital revolution helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.