Roles and Responsibilities :
- Design and develop data pipelines using Cortex, ETL processes to extract, transform, and load data from various sources into a centralized repository.
- Collaborate with cross-functional teams to identify business requirements and design solutions that meet those needs.
- Develop complex SQL queries to optimize database performance and troubleshoot issues.
- Ensure high-quality delivery of projects by testing, debugging, and deploying code in production environments.
Job Requirements :
- 10-15 years of experience in software development with expertise in Cortex, ETL tools (e.g., Informatica PowerCenter), and SQL programming language.
- Strong understanding of Linux operating system administration principles.
- Experience working on large-scale enterprise applications with multiple stakeholders.
- Deep understanding of Snowflake's unique architecture (separation of storage and compute) and features.
- Hands-on experience with Snowflake and SQL, including query optimization.
- Participate in design discussions with architects, security teams, and development teams.
- Design and implement scalable Snowflake data architecture solutions.
- Ensure Snowflake solutions are secure, scalable, and resilient,
following Snowflake solutions to compliance standards.
- Define data models, schemas, and ETL/ELT pipelines for structured and semi-structured data
- Knowledge of data warehousing and ETL/ELT
- Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integrations
- Knowledge of DevOps and CI/CD practices for data pipelines and workflows
- Experience in data engineering or database development, particularly with data migrations
- Strong expertise in Snowflake administration (user management, warehouses, roles, resource monitors, Replication, and disaster recovery process.
- Knowledge of Snowflake features: Time Travel, Cloning, Micro-partitions, Streams & Tasks.
- Positive understanding of private connectivity, network rules and policies, authentications etc
- Hands on experience in Snowflake features like external stages, snowpipe, storage integration, File Formats, RBAC etc
- Proficiency in Scripting skills in Python, Shell, or PowerShell for automating regular administrative or repeating task.
- Good understanding of various cost incurred in Snowflake.
- Experience with ETL processes and data integration workflows.
- Strong problem-solving and analytical skills.
📌 snowflake architect (Hyderabad)
🏢 CES
📍 Hyderabad