Fowzia Bhanu Patan

Project : Ooredo Telecom

Environment : Snowflake, Azure Blob and Oracle SQL

Client : Ooredo

• Bulk loading from external stage (Azure Blob), internal stage to snowflake cloud using COPY command.
• Loading data into snowflake tables from internal stage using snowsql.
• Used COPY, LIST, PUT and GET commands for validating internal stage files.
• Used import and Export from internal stage (snowflake) from external stage (Azure Blob).
• Used FLATTEN table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column.
• Used SNOW PIPE for continuous data ingestion from the Azure Blob.
• Created clone objects to maintain zero-copy cloning.
• Data validations have been done through information_schema.
• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake
• Cloned Production data for code modifications and testing.
• Involved in Requirement Analysis & preparation of Functional Design documents.
• Table DDLs creation in snowflake development database.
• Have used COPY statements to ingest data from stage to Tables.
• Implemented snow pipe for real-time data ingestion.
• Cloned Production data for code modifications and testing.
• Work with multiple data sources.
• Worked with streams for change data capture and implemented SCD.
• Implemented solutions using snowflake’s data sharing, cloning and time travel.
• Establish and ensure adoption of best practices and development standards.
• Communicate with peers and supervisors routinely, document work, meetings, and decisions.
• Loading data into Snowflake tables from internal stage and on local machine.
• Writing Snowflake sql scripts in Snowflake cloud data warehouse to Business Analysis and reporting.
• Responsible for task distribution among the team.
• Perform troubleshooting analysis and resolution of critical issues.
• Created database according to business requirement
• Created Snowpipe for continuous data load.
• Worked on Data validation between Oracle and Snowflake databases.
• Created internal, external stage and transformed data during load.
• Shared sample data using grant access to customer for User Acceptance Testing(UAT).
• Experience in using Snowflake Clone and Time Travel and Worked with Streams & Tasks.
• Involved on Data cleansing, is process of detecting and correcting or removing inaccurate data or records from database.

Project : National Grid

Environment : Snowflake, Azure Blob and Oracle SQL

Client : National Grid UK

• Involved in Migrating Objects from SQL to Snowflake.
• Created Snowpipe for continuous data load and bulk data load purpose used copy command.
• Created internal and external stage and transformed data during load.
• Cloned Production data for code modifications and testing.
• Shared sample data using grant access to customer for UAT.
• Historical data retrieved by using Time travel and also used for missed data to recover.
• Heavily involved in testing Snowflake to understand best possible way to use t cloud resources
• Created data sharing out of snowflake with testing team.
• Worked with streams for change data capture and implemented SCD.
• Created database according to business requirements.
• Worked on Data validation between Oracle and Snowflake databases.

Project : LB Group

Environment : Snowflake, Informatica and Oracle SQL

Client : LB Group

• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from diverse sources such as source flat files and oracle tables to target tables.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.
• Identifying and analyzing the business need of the end-users requirements.
• Developed SQL queries based on customer requirement using various joins.
• Performing all SDLC phases to complete ETL development work (Requirement Gathering, Analysis, Design, Unit Testing, Deployment)
• Executing the automated scripts and updating the logs. Involved in execution of the scripts with respect to functionality.
• Committed developed script using Git repository.
• Issues reporting/clarifications, raising bugs if product issues.
• Attending daily stand-up meeting and give updates.
• Team Management in knowledge transfer as well as mentoring activities
• Providing weekly & monthly report on project activities and performance.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
• Working on effort estimation of change requests.
• Performing data analysis and resolution of issues as part of production support
• Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS, and Mart.
• Involved in Design, analysis, Implementation, Testing, and support of ETL processes for Stage, ODS, and Mart.
• Developed reusable Mapplets and Transformations. Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times. Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.