Python and Snowflake developer
Role details
Job location
Tech stack
Job description
Tata Consultancy Services in Spain is looking for a Python and Snowflake developer for designing ETL/ELT workflows and integrating APIs. The position involves collaborating with data architects and ensuring the compliance of security standards., * Design and implement ETL/ELT workflows using Python.
- Build and manage REST/SOAP API integrations.
- Write high-performance Snowpark or SQL code.
- Collaborate with architects to design schemas.
- Develop automated testing and monitoring systems.
- Ensure data integrations comply with security standards.
Conocimientos
Python Skills Snowflake Expert SQL Proficiency API Architecture Version Control Cloud Infrastructure English Descripción del empleo Overview
Are you a Python and Snowflake developer seeking a new interesting challenge?
If your answer is yes, it's your lucky day so keep reading, it can be just what you're looking for!, * Pipeline Development: Design and implement ETL/ELT workflows using Python to ingest data from various sources (SaaS APIs, SQL databases, NoSQL) into Snowflake.
- System Integration: Build and manage REST/SOAP API integrations to synchronize data between Snowflake and third-party platforms.
- Optimization: Write high-performance Snowpark or SQL code to transform data within Snowflake, ensuring cost-effective warehouse usage.
- Data Modeling: Collaborate with data architects to design schemas that support efficient reporting and analytics.
- Automation & Monitoring: Develop automated testing, error handling, and alerting systems to ensure pipeline reliability.
- Security: Ensure all data integrations comply with security standards (encryption at rest/transit, OAuth, etc.).
Requirements
- Minimum 3 years of experience in Python.
- Deep understanding of Snowflake architecture.
- Ability to write and optimize complex SQL queries.
- Proven experience with RESTful services and JSON.
- Professional experience with Git.
- Familiarity with cloud infrastructure services.
- Intermediate level of English., * Python Skills: Minimum 3 years of experience. Expert knowledge of libraries like pandas, requests, SQLAlchemy, and ideally Snowpark.
- Snowflake Expert: Deep understanding of Snowflake architecture (Virtual Warehouses, Micro-partitions, Snowpipe, and Tasks).
- SQL Proficiency: Ability to write and optimize complex analytical queries.
- API Architecture: Proven experience working with RESTful services, JSON, and authentication protocols.
- Version Control: Professional experience with Git (GitHub/GitLab).
- Cloud Infrastructure: Familiarity with AWS, Azure, or GCP (specifically storage services like S3 or Blob Storage).
- English: Intermediate level
Benefits & conditions
Competitive salary and flexible compensation Monthly support for working from home Career development plan Learning platforms Referral bonus Corporate discounts Team building opportunities Sustainability programs, Required skills include expertise in Python and Snowflake, as well as SQL and API architecture knowledge. The role offers a hybrid work model with competitive pay and benefits, including healthcare and career development opportunities.
Join a global company recognized for its commitment to inclusion, diversity, and employee wellbeing., Work Schedule: Business Hours What We Offer
- Permanent contract - We offer indefinite contracts from the first day.
- Pay and benefits - Competitive salary and a flexible compensation plan adapted to your needs (Ticket restaurant plan, Childcare Ticket, Transport Ticket and Health Insurance).
- Work from home - Monthly financial support for working from home expenses, plus a first-month setup bonus.
- Career development - Career development plan and annual performance-based compensation reviews.
- Learning and growth - Onboarding program and learning platforms to grow professionally.
- Referral bonus - Refer a friend under the BYB Scheme and you'll receive a cash award if hired.
- Global collaboration - Work with people from all over the world.
- TCSer benefits - Corporate discounts and benefits as part of the TCS Spain family.
- Additional programs - Appreciations, incentives, team building, diversity and inclusion, sustainability programs, etc.