Snowflake Developer

Job Description Who we are?At Hexaware Technologies, we are a leading global IT Services company, dedicated to driving digital transformation and innovation for businesses around the world. Founded in 1990, Hexaware has grown into a global trusted partner for enterprises, offering comprehensive AI empowered services including IT Consulting, Application Development, Infrastructure and Cloud Management and Business Process services. At Hexaware we are a community of creative, diverse, and open-minded Hexawarians creating smiles through the power of great people and technology. We pride ourselves on our people-centric culture and commitment to sustainability. Our diverse team of over 30,000 professionals across 30 countries is driven by a shared passion for innovation and excellence. We foster a collaborative environment where creativity and continuous learning are encouraged, enabling our employees to thrive and grow. Snowflake Developer with SSIS Primary Skillset:Data Modeling & ETL: Design, develop, and optimize data models and ETL processes using Snowflake for efficient data storage and analytics.Design and implement end-to-end ETL pipelines for loading data from various sources into Snowflake.Utilize Snowflake’s built-in features such as tasks, streams, and Snowpipe to automate the ETL process for continuous and batch data loads.Implement data transformation logic using SQL, Snowflake Stored Procedures (SQL and Python), and ETL tool to ensure the integrity, accuracy, and consistency of data.Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features.Optimize and tune Snowflake queries, Data Storage, Warehouse for performance and efficiency.Migration & Integration: Experience with data migration, particularly from SQL Server to Snowflake, and integrating Snowflake with other data sources.Collaborate with data architects and business stakeholders to understand data requirements.Develop and maintain documentation for data processes and solutions.Ensure data quality, governance, and security within the Snowflake environment.Troubleshoot and resolve issues related to the Snowflake data warehouse.Stay updated with the latest Snowflake features and best practices.API Integrations: Work on integrating Snowflake with external APIs for seamless data extraction and transfer.Design, develop, and maintain SSIS ETL packages for complex data integration and transformation requirements. Support existing SSIS packages during US off-hours Make updates to SSIS packages to add additional fields to be extracted DevOps Integration - SecondaryAzure DevOps Experience: Proficiency with Azure DevOps for:Source control managementAutomating deploymentsDeploying Snowflake scripts across different environmentsManaging ETL pipeline deploymentsProficiency in DevOps tools and best practices, with experience deploying Snowflake and ETL tool services. Qualifications:Proven experience as a Snowflake Developer with hands-on experience in Snowflake data warehousing solutions.Data Architecture: Strong understanding of Snowflake platform features, including micro-partitioning, file processing from AWS S3, and data quality practices.Expertise in writing and optimizing SQL queries, including complex queries, CTEs, and stored procedures (using JavaScript within Snowflake).Solid experience in working with Snowflake’s micro-partitioning, file processing from AWS S3, and optimizing data models.Strong knowledge of Python for data engineering tasks and automation.Background in data migration, specifically from SQL Server to Snowflake.Familiarity with designing and managing data pipelines and ETL processes.Excellent communication skills and the ability to collaborate effectively with cross-functional teams. Preferred Skills:Experience in using the ETL tools like DBT/SnapLogic/Talend/Informatica/Fivetran for building ETL pipelines, testing, and deploying transformation models. DBT/SnapLogic is preferred.Snowpark for Python/Scala: Strong knowledge of Snowpark for building scalable data pipelines and implementing advanced analytics workloads.Hands-on experience with AWS services and DevOps tools (e.g., CloudFormation, Terraform) for deploying AWS resources such as Lambda, SQS, and SNS.Familiarity with legacy Microsoft SQL platforms and integrating these with modern cloud-based data solutions.Strong problem-solving skills and the ability to thrive in a collaborative and fast-paced environment.