SourceVinsys Information Technology, Inc
Location NY Job description:
- Oracle to Snowflake Migration Developer with AWS
- Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etcto do Extract, Load, and Transform data
- Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
- In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
- Experience gathering and analyzing system requirements
- Good working knowledge of any ETL tool (Informatica or SSIS)
- Good to have familiarity with data visualization tools (Tableau/Power BI)
- Ability to effectively function in a cross-team's environment
- Good to have exposure to AWS / Azure Data ecosystem
- A solid experience and understanding of architecting, designing and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must.
- Need to have professional knowledge of AWS Redshift Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake.
- Developing scripts Unix, Python etcto do Extract, Load and Transform data Working knowledge of AWS Redshift Provide production support for Data Warehouse issues such data load problems, transformation translation problems Translate requirements for BI and Reporting to Database design and reporting design.
- Understanding data transformation and translation requirements and which tools to leverage to get the job done Understanding data pipelines and modern ways of automating data pipeline using cloud based Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Basic Qualifications Minimum 1 year of designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse
Senior SnowFlake Developer
Snowflake & Python Developer