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.

 

WORK EXPERIENCE:

 

• Working as a Software Engineer March’2018 to till date.

 

TECHNICAL SKILLS:

 

ETL Tools                     : Informatica, Matillion

Data Modelling         : Erwin4.2.2, Visio 2000, Power Designer.

Data Bases                  : Oracle/SQL Server/SnowFlake, AWS

Languages                 : SQL, T-SQL PL/SQL, Python

Operating Systems     : Windows/Unix