Python and Snowflake developer
Role details
Job location
Tech stack
Job description
Tata Consultancy Services is seeking a Python and Snowflake developer in Almería, Spain. The role involves designing ETL workflows and managing API integrations to enhance data processing in Snowflake., * Design and implement ETL/ELT workflows using Python for data ingestion into Snowflake.
- Build and manage REST/SOAP API integrations between Snowflake and third-party platforms.
- Write high-performance Snowpark or SQL code for data transformation in Snowflake.
Conhecimentos
Python Skills Snowflake Expert SQL Proficiency API Architecture Version Control Cloud Infrastructure Intermediate English Descrição da oferta de emprego
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. WHAT WILL YOU DO?
- 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
Candidates should have at least 3 years of Python experience and understand Snowflake architecture well. The position offers a hybrid work model with a permanent contract and competitive pay from day one., * Minimum 3 years of experience in Python development, expert knowledge of libraries like pandas and SQLAlchemy.
- Deep understanding of Snowflake architecture, including Virtual Warehouses and Snowpipe.
- Ability to write and optimize complex analytical SQL queries., * 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).
- Intermediate level of English.
Benefits & conditions
- Permanent contract: We offer indefinite contracts from the first day.
- Pay and benefit.