Naga Prabhakar Gogula
Sheffield
Summary
Over 5 years of IT experience in Data warehousing and Business intelligence with an emphasis on Project Planning & Management, Business Requirements Analysis, Application Design, Development, testing, implementation, and maintenance of client/server Data Warehouse. Seeking to have a challenging career in Data Warehousing and Business Intelligence with growth potential in technical as well as functional domains and to work in critical and time-bound projects where can apply technological skills and knowledge in the best possible way.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Engineer (Snowflake Developer)
Radson Technology Limited
07.2022 - Current
- Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
- Loading data into snowflake tables from the internal stage using snowsql.
- Used COPY, LIST, PUT and GET commands for validating the internal stage files.
- Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).
- Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
- Used FLATTEN table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column.
- Used SNOW PIPE for continuous data ingestion from the S3 bucket.
- Developed snowflake procedures for executing branching and looping
- 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
- Experience with AWS cloud services: EC2, S3, EMR, RDS, Athena, and Glue
- Cloned Production data for code modifications and testing
- Perform troubleshooting analysis and resolution of critical issues
ETL Developer
Hexa System Pvt Ltd
04.2018 - 05.2022
- Expertise in identifying and analyzing the business need of the end-users and building the project plan to translate the functional requirements into the technical task that guide the execution of the project.
- Served as a liaison between third-party vendors, business owners, and the technical team.
- Proven ability in communicating highly technical content to non-technical people.
- 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.
- 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.
- 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.
- Involved in writing procedures, functions in PL/SQL
Education
Master of Science - Big Data Science And Technology
University of Bradford
Bradford, United KingdomSkills
Cloud Technologies: Snowflake, AWS
Programming Languages: Pl/SQL, Python(pandas),SnowSQL
Dashboard: Elastic Search, Kibana
Data Warehousing: Snowflake Teradata
DBMS: Oracle,SQL Server,MySql,Db2
Operating System: Windows, Linux, OS X
IDEs: Eclipse,Netbeans
Servers: Apache Tomcat
Data Integration Tool: NiFi, SSIS
Certification
Power BI Microsoft Developer
Timeline
Data Engineer (Snowflake Developer)
Radson Technology Limited
07.2022 - Current
ETL Developer
Hexa System Pvt Ltd
04.2018 - 05.2022
Master of Science - Big Data Science And Technology
University of Bradford
Similar Profiles
Ahmed Al AsbahiAhmed Al Asbahi
Group Chief Financial Officer at Timeline Technology Solutions; Pivot Payments Limited; Ctrack Middle East & Africa TechnologyGroup Chief Financial Officer at Timeline Technology Solutions; Pivot Payments Limited; Ctrack Middle East & Africa Technology
Kumar SonuKumar Sonu
Software Engineer at SynapseWave Innovation Private Limited (formerly 63 Moons Technology Limited)Software Engineer at SynapseWave Innovation Private Limited (formerly 63 Moons Technology Limited)
Sourav GangulySourav Ganguly
Team Manager at Capgemini Technology Services India LimitedTeam Manager at Capgemini Technology Services India Limited
Gemma HolmesGemma Holmes
Payroll Manager at iConsult Payment Solutions LimitedPayroll Manager at iConsult Payment Solutions Limited
Faisal JahangirFaisal Jahangir
Customer service advisor at Currys PC WorldCustomer service advisor at Currys PC World