Telstra, Systems Engineer (Snowflake Developer), Snowflake Cloud Data Warehouse, AWS, Telstra Corporation Limited is an Australian telecommunications company which builds and operates telecommunications networks and markets voice, mobile, internet access, pay television and other products and services. It is a member of the S&P/ASX 20 and Australia's largest telecommunications company by market share. Telstra is the largest wireless carrier in Australia, with 18.8 million subscribers. Telstra has transitioned from a state-owned enterprise to a fully privatized company and has recently focused on diversified products and emerging technologies, Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale Snowflake cloud data warehouse., Bulk loading from external stage (AWS S3), External stage (snowflake) using COPY command., Loading data into Snowflake tables from internal stage and on local machine., Used COPY, PUT and GET commands for validating internal and external stage files., Used import and export from internal stage (Snowflake) vs external stage (S3 Bucket)., Writing Snowsql scripts in Snowflake cloud data warehouse to Business Analysis and reporting., Responsible for task distribution among the team., Perform troubleshooting analysis and resolution of issues., Involved in data analysis and handling ad-hoc requests by interacting with business analysts, clients and resolve the issues as part of production support., Used performance technics like clustering key, autoscaling for faster way of loading, increase query execution., Performed data validations for source and target using load history and copy history., Developed snowflake queries using various joins like self, left, right and full outer joins., Created views and materialized views and snowflake procedures., Worked on assigning roles to various users like development, testing etc... TESCO, Data Analyst, MY SQL, Tesco operates a mobile phone business across the United Kingdom, Ireland, Slovakia, Hungary and the Czech Republic. It first launched in the UK in 2003 as a joint venture with O2 and operates as a mobile virtual network operator using the network of O2 with the exceptions of Hungary where the network of Vodafone Hungary is used and Ireland where Three Ireland is used. As a virtual operator, Tesco Mobile does not own or operate its own network infrastructure. By January 2011 Tesco announced it had over 2.5 million UK mobile customers Tesco acquired a small I.T. support company called The PC Guys in 2007 and were able to launch Tesco Tech Support in December 2008. operates a home shopping service as well., Prepared reports as per the requirement from BI team on weekly, monthly & quarterly basis., Created many database objects such as Tables, Views, Stored Procedures, User Defined Functions, Cursor using MYSQL, Wrote SQL queries using joints, sub queries to retrieve data from the database., Code validation as per client requirement and involved in in daily run for regression., Testing of code functionality using testing environment., Managing and coordinating the team to deliver to queries., Strong Knowledge of CTE (Common table expression) and Recursive CTE.
