Snowflake Developer
IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.
Job Reference Number: 23-86852
Location: Wayzata, MN 55391
Job Type: Contract to hire
Responsibilities:- Developing and maintaining ETL processes, data pipelines and data integration processes with Snowflake
- Creating and maintaining views, stored procedures, and other database objects in Snowflake
- Designing and implementing features for identity and access management, authorization frameworks, and data security and access control
- Implementing query optimization, encryption, transaction management, and distributed data processing algorithms
- Solving performance issues and scalability issues in the system
- Creating and maintaining the documentation of the architecture, data models and maintenance activities
- Reviewing and auditing existing data models and solutions and proposing better processes
- Conducting efficient data integration with other third-party tools and Snowflake
- Evangelizing and promoting Snowflake platform within their organization
Qualifications /Skills:- Must have 6-8 years of experience in MySQL Aurora database concepts and architecture.
- Must have 2-3 years of experience in Snowflake database (Streams, Procedures, Tasks, Snow pipe)
- Must be hands on in designing/defining architecture for solutions in MySQL, need basic administration knowledge of MySQL.
- Must be hands on to develop Procedures, Triggers, Functions in MySQL Aurora DB
- Must be aware about the optimization/ Query performance tuning techniques of ySQL to handle very large datasets.
- Must be aware about bulk update/insert concepts of MySQL.
- Must have knowledge on AWS, S3
- Knowledge of QLIK replicate tool (Full load, CDC load etc)
- Knowledge of QLIK replicate transformation, lookup components, inbuilt function usage etc.
- Knowledge of QLIK replicate job tuning parameters
Minimum Qualification Requirement- Bachelor's degree with 6+ years of experience in applicable field OR Advanced Degree in applicable field with 4+ years of relevant experience
Schedule:
**The above pay range represents the expected salary range for this job requisition. In determining your pay, we'll consider your location, experience, and other job-related factors.
Salary Range: $55 to $60 Per Hour on W2
- Monday to Friday
- 08:00 AM - 05:00 PM
Safety:
Vaccination against COVID-19 may be a requirement for this job in compliance with current client and governmental policies. An IMCS Group recruiter will confirm and share more details with you during the interview process.
IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company. •
Last updated on Nov 14, 2023