نبذة عني
Around 4.5+ Years of professional IT experience in this area of snowflake cloud data warehouse and snowflake developer. Having 3.5years of Professional Experience in working with Snowflake cloud, AWS S3 and Having experi…
Around 4.5+ Years of professional IT experience in this area of snowflake cloud data warehouse and snowflake developer. Having 3.5years of Professional Experience in working with Snowflake cloud, AWS S3 and Having experience in-depth knowledge of Software Development Life Cycle, Agile, Waterfall, and Scrum methodologies. Excellent experience in Warehouses, Roles, Schema, Databases, and Resource Monitoring. Strong experience in Snowflake Multi-Cluster Warehouse, virtual warehouses, Snow SQL, and Snow Pipe. Handling large and complex datasets like JSON, ORC, PARQUET, CSV files from various sources like AWS S3, MS Azure. Used COPY/INSERT, PUT, and GET commands for loading data into Snowflake tables from internal/external stage. Created and used Snowflake Database, Schema, and Table structures. Experience in using Snowflake Clone and Time Travel. Extensively worked on Data Building Tool (DBT) and defining Schemas/ Modules and developing the models using SQL. Experience building and deploying dbt models for data transformation using Snowflake. Experience using dbt packages and plugins for specific transformations or integrations. Knowledge of best practices for data quality and testing within dbt workflows. Writing advanced SQL scripts as per the business plan to transform the data. Used Time Travel and Fail Safe for data recovery. In-Depth understanding of Snowflake Multi-cluster warehousing, Multi-cluster Size, and Credit Usage. Experience in working with various data formats like XML, JSON, and CSV files. Knowledge of Dimensional Modeling, Star and Snowflake Schemas. Implementation of knowledge on Time Travel and Fail Safe for data recovery. Created Resource Monitoring to control billing (credit limit). Creating Snowflake Roles and Users and data masking to maintain security standards.
الخبرة
Data Engineer
• Understand the business requirement and architecture that represents data lineage.
• Experience with snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems.
• Experience in building Snow Pipe.
• Worked on AWS data pipeline to configure data loads from S3 data.
• In-depth knowledge of Data Sharing in Snowflake.
• Exposure on using Snowflake Database, Schema, and Table structures.
• Experience in using Snowflake Clone and Time Travel.
• Writing advanced SQL scripts as per the business plan to transform the data.
• Used Time Travel and Fail Safe for data recovery.
• Created Data sharing to share data with other account Users.
• Worked on Streams, Task, SCD Type1 and Type2.
Software Engineer
SQL supporting developer
Creating and altering database objects like tables, views, Stored Procedures, and Functions.
Designing the database constraints and having exposure to Explain Plan.
Involved in database backup/Restore in SQL Server Databases.
Program complex SQL server procedures and functions.
Database design and development.
Configure and develop SQL Server Integration Services.
Write technical procedures and documentation for the applications including operations, user guide, etc.
MS SQL Server platform.
Configure and develop SQL Server Reporting Services Analyze data contained in the databases and identify data integrity issues.
Troubleshoot technical issues and identify modifications needed in existing applications to meet changing user requirements
Snowflake Developer
Understand the business requirement and architecture that represents data lineage.
Experience with snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems.
Experience in building Snow Pipe.
Worked on AWS data pipeline to configure data loads from S3 data.
In-depth knowledge of Data Sharing in Snowflake.
Exposure on using Snowflake Database, Schema, and Table structures.
Experience in using Snowflake Clone and Time Travel.
Writing advanced SQL scripts as per the business plan to transform the data.
Used Time Travel and Fail Safe for data recovery.
Created Data sharing to share data with other account Users.
Worked on Streams, Task, SCD Type1 and Type2.