Snowflake Developer

*Position: Snowflake Developer* *Location: Coppell, TX (HYBRID)* *Tax Term: W2 Only* *Job Summary:* *Skills:* Data Management, Snowflake cloud warehouse, ETL pipelines in and out of data warehouse, Python and Snowflake SQL, scripts using Unix shell, Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting *Job Description* * Minimum 8 years of experience in Data Management and specialized in Analytical data warehouse. * Minimum 3 years hands on experience with Snowflake cloud warehouse and its features. * Good knowledge on cloud AWS architecture and its services. * Experience in creating and analyzing SQL and PL/SQL procedures for data integration. * Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflake SQL. Developing scripts using Unix shell to do Extract and Load data. * Good understanding of logical and physical data models to support analytics and business intelligence. * Experience in creating SQL based processes to build slowly changing dimension and various type of facts. * Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting, Profiling Archiving, Purging Virtualization, Metadata Management, Performing Unit Test, System integration test Support, UAT. * Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them. * Engaged in project using Agile methodology and documentation using Jira * Strong verbal and written communication skills. *Must have:* * Minimum 8 years of experience in Data Management and specialized in Analytical data warehouse. * Minimum 3 years hands on experience with Snowflake cloud warehouse and its features. * Good knowledge on cloud AWS architecture and its services. * Experience in creating and analyzing SQL and PL/SQL procedures for data integration. * Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflake SQL. Developing scripts using Unix shell to do Extract and Load data. * Good understanding of logical and physical data models to support analytics and business intelligence. * Experience in creating SQL based processes to build slowly changing dimension and various type of facts. * Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting, * Profiling Archiving, Purging Virtualization, Metadata Management, Performing Unit Test, System integration test Support, UAT. * Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them. Engaged in project using Agile methodology and documentation using Jira Strong verbal and written communication skills. *Rishabh Kumar* *Talent Advisor, Cybotic Systems* *(254) 452-0118 | www.cyboticsystems.com* *rishabh@cyboticsystems.com* Job Type: Full-time Pay: Up to $65.00 per hour Benefits: * 401(k) * 401(k) matching * Dental insurance * Flexible schedule * Health insurance * Paid time off * Vision insurance Schedule: * Monday to Friday Application Question(s): * It's a W2 Role. Are you open for W2? Work Location: In person