Overview
Skills
Job Details
HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Data Analyst in Smithfield RI. Below is the detailed job description.
Title: Data Analyst
Location Smithfield RI- Hybrid
Skills: AWS,Snowflake,Python,Informatica, SQL, MySQL
Data Integration Lead
Job Description:
Having 6 -9 years of experience in design, develop, and maintain Snowflake Data Warehouse solutions for large-scale data processing. |
Proficiency in developing ETL/ELT processeing tools using Informatica, Python along with AWS services like Glue,Lambda |
Strong database design, relational and dimensional modeling, and SQL skills |
Model complex business requirements into efficient SQL queries and stored procedures to support reporting needs. |
Collaborate with cross-functional teams to design scalable architectures for data workloads on Snowflake platform. |
Ensure high availability, performance, security, and compliance of the entire system. |
Strong expertise in writing complex SQL queries including joins, aggregations, window functions etc. |
Experience with data modeling techniques to create efficient star schemas or other types of databases designs. |
In-depth knowledge and Proven practical experience in migrating data from on-prem to cloud using Snowflake,Python & AWS services |
In depth understanding of Snowflake Architecture including Snow SQL, Performance tuning, Compute and Storagea |