Must Have Skills:
· Snowflake
· ETL DW Experience
· Unix
Detailed Job Description:
· 10+ years of experience
· At least 5+ yrs. of experience managing large projects with the below experiences
· Experience in working large teams in Onsite/Offshore model
· Working experience in Snowflake, PLSQL, any ETL expertise
· Strong knowledge of DW/BI concepts
· Good Communication skills
· Facilitate design and develop processes utilizing best standards.
· Develop solutions in accordance with the client specifications.
· Assist development teams to maintain all data sources and data storage options.
· Coordinate with application team and develop all ETL processes.
· Provide an efficient interface with brand for all processes across various platforms.
· Administer all requests and analyze issues and provide efficient resolution for same.
· Prepare codes for all modules according to require specification
· Design all programs and systems and associate documentation for same.
· Strong knowledge of snowflake functions and features
· Past experience in building denormalized data sets for analytics; data sets can be batch or near real time in refresh frequency
· Experience in creating and enhancing framework to build data sets
· Strong skills in python scripting and SnowSQL
· Monitor all production issues and inquiries and provide efficient resolution for same.
· Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.
· Collaborate with application groups to prepare effective solutions for all programs.
· Document all technical specifications and associate project deliverables.
· Strong in writing complex SQL/PLSQL optimized queries
· Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
· Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
· Resolve complex issues arising in projects execution.
· Perform realistic assessments of development time.
· Conduct research and analysis to create innovative solutions.