Job description
Responsibilities:
Design, develop, and optimize Snowflake data warehouse solutions to meet business requirements.
Collaborate with stakeholders to gather and understand data requirements, and translate them into technical specifications.
Perform data modeling and schema design to ensure efficient and scalable data storage and retrieval.
Develop and maintain ETL processes using Snowflake's features and capabilities, such as stored procedures, tasks, and streams.
Implement data integration pipelines to ingest data from various sources into Snowflake, ensuring data quality and integrity.
Optimize queries and data processing for performance and scalability, utilizing Snowflake's indexing, clustering, and partitioning techniques.
Troubleshoot and resolve data-related issues, including data quality, data transformation, and performance bottlenecks.
Collaborate with cross-functional teams, including data engineers, data analysts, and business stakeholders, to deliver high-quality data solutions.
Stay up-to-date with the latest Snowflake features and best practices, and evaluate their applicability to enhance existing systems.
Requirements:
Must have 6+ yrs. experience in Snowflake, ETL tools like Informatica, DMX and Data analysiso Must have 3+ yrs. experience in Pythono Hands on exposure into Unix, Unix shell Scripting
o Must have hands on experience in Oracle, SQL, PostgreSQL, Snowflake.o Must have hands on Data Warehousing
o Experience in Hadoop, Sqoop, Hive will be added advantage.
o Good to have experience in AWS cloud stack with experience in Aws S3 Athena preferred.
o Must understand any scheduling tools like, Autosys, Control-M, Tivoli etc
o Should be able to handle client independently, take up requirements and suggest solution whenever required
Preferred Skills:
Snowflake certification(s).
Experience with data visualization tools, such as Tableau or Power BI.
Knowledge of scripting languages like Python or Shell scripting.
Familiarity with data governance and data security practices.
Originally posted on Himalayas
Who can apply
Eligible countries: United States. Accepted UTC offsets: UTC-10, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.