Koteswara, Snowflake Developer | Bench Resource on Contract

Koteswara (RID : yb8plkxjxdpb)

Snowflake Developer

Location : Pune, India

Experience : 5 Year

Rate: $14 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 2

Total Views : 79

Key Skills

Snowflakes Matillion Informatica Oracle and SQL Server ETL

Discription

PROFESSIONAL SUMMARY:

Over 5 years of experience in all phases of Analysis, Design, Development, Data Modeling Implementation, and support of Data warehousing Applications using tools like SnowFlake, Matillion, Informatica, AWS, Oracle and SQL Server.
Expertise in ETL operations using Informatica (Power Center 8/9/10)
Expertise in developing the mappings, and workflows in Matillion.
Expertise in developing the mappings, sessions and workflows in Informatica.
Good knowledge in Project Management, Business Analysis, Business Modeling and Data Modeling.
Strong experience in supporting the production jobs and analyzing the failures
Define virtual warehouse sizing for Snowflake for different type of workloads.
Experience in building Tasks, Streams, Materialized Views and Snowpipe.
Develop transformation logic using snowpipeline.
Experience in using Snowflake Clone and Time Travel.
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe techniques
Develop SQL queries in SnowSQL and optimize and fine tune queries
Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which includes data load into snowflake table.
Mentor and train junior team members and ensure coding standard is followed across the project.
ETL pipelines in and out of data warehouse using combination Snowflakes SnowSQL Writing SQL queries against Snowflake.
Managed the Coe for multiple practices by reviewing and managing the Coe Artifacts
Expertise in prioritizing the tasks and decision making during the different phases of project
Expertise in identifying the key issues/Risk in the project and bringing them to closure
Experienced in cloud-based snowflake to extract data from Amazon S3 and Azure for business intelligence
Experienced in sprint planning and sprint retro activities in agile methodology as certified scrum master.
Experienced in handling multiple project and teams in the onsite-offshore model collaboratively.
Involved in doing the POC and convincing the clients to get the approvals to new projects
Strong analytical, communication, leadership and problem-solving skills.
Expertise in Project Management, Business Analysis, Business Modeling and Data Modeling
Expertise in Performance tuning of ETL and Database routines to reduce the data load time
Strong knowledge on ETL concepts, Star schema and Snow flake data models
Proficient in Data Mart, Star Schema, Extract, Transform and Load the Data, Requirement Analysis, Design, Development, Testing. Documentation and Implementation of Business Applications.
Good at communicating with onshore team and handling clients, setting up meetings.
Able to evolve myself within new environment and good at understanding new technologies.