Hi, I’m
Ramesh Kumar Lokonda
Summary
Over 7 years of IT experience in Data warehousing with an emphasis on Business Requirements Analysis, Development, testing, implementation, and maintenance of 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
7
years of professional experience
Work History
Space MultimediaHyderabad
Data Engineer (Snowflake Developer)
06.2022 - Current
Job overview
- 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
Delta TechnologyHyderabad
ETL Developer
06.2021 - 06.2022
Job overview
- 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
DeloitteHyderabad
ETL Consultant
01.2021 - 06.2021
Job overview
- Created Snowpipe for Continuous data loading.
- Use COPY to bulk load the data.
- Understanding the business rules completely and implemented data transformation Methodologies.
- Extracted the data from the flat files and populated onto Data warehouse.
- Developed mappings to load into Dimensions and Facts.
- To design the mapping with slowly changing dimensions type 2 to keep track of historical data.
- Design a mapping using Router, Lookup, Expression, Filter and Aggregator transformation in getting related values.
- Develop data loading process with session parameters.
- Deploy the informatica objects, database package and Autosys jobs to higher environments.
BMCPune
Senior Consultant
01.2020 - 12.2020
Job overview
- worked on Snowsql and Snowpipe
- Understanding the business rules completely and implemented data transformation Methodologies.
- Extracted the data from the flat files and populated onto Data warehouse.
- Developed mappings to load into Dimensions and Facts.
- To design the mapping with slowly changing dimensions type 2 to keep track of historical data.
- Design a mapping using Router, Lookup, Expression, Filter and Aggregator transformation in getting related values.
- Created mapplets to use them in all the fact mappings, to validate the identifiers not present in feed file, share class id's not present in share class table and duplicate identifies.
- Develop data loading process with session parameters.
- Deploy the informatica objects, database package and Autosys jobs to higher environments through ubs deploy tool.
INFOSYSPune
Tech Lead
06.2017 - 01.2020
Job overview
- Understanding the business rules completely and implemented data transformation Methodologies.
- To design the mapping with slowly changing dimensions type 2 to keep track of historical data.
- Design a mapping to process the incremental changes that exists in the source.
- Involved in designing the mapplet and reusable transformation according to business needs.
- Design a mapping using Router, Lookup, Filter and Aggregator transformation in getting related values.
- Design a mapping with multiple loading using File Repository.
- Develop data loading process with session parameters.
WIPROPune
Software Engineer
06.2016 - 03.2017
Job overview
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Coordinated with other engineers to evaluate and improve software and hardware interfaces.
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
- Updated old code bases to modern development standards, improving functionality.
Education
J N T U KakinadaNarsipatnam, Andhra Pradesh
Master of Science from Software Engineering
12.2010
Skills
Cloud Technologies: Snowflake, AWS
Programming Languages: SQL ,SnowSQL
DataWarehousing: Snowflake
DBMS: Oracle,SQL Server
Operating System: Windows, Linux, OS X
Data Integration Tool: Informatica PowerCenter , IICS
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Engineer (Snowflake Developer)
Space Multimedia
06.2022 - Current
ETL Developer
Delta Technology
06.2021 - 06.2022
ETL Consultant
Deloitte
01.2021 - 06.2021
Senior Consultant
BMC
01.2020 - 12.2020
Tech Lead
INFOSYS
06.2017 - 01.2020
Software Engineer
WIPRO
06.2016 - 03.2017
J N T U Kakinada
Master of Science from Software Engineering
Similar Profiles
MUKESH DABBAKUTIMUKESH DABBAKUTI
Motion Graphics Artist at Space MultimediaMotion Graphics Artist at Space Multimedia
Nick CrankshawNick Crankshaw
Account Executive at Doctor MultimediaAccount Executive at Doctor Multimedia
EMMANUEL AZUMAH PINENSOEMMANUEL AZUMAH PINENSO
IT Technician at SEA MULTIMEDIA HOUSEIT Technician at SEA MULTIMEDIA HOUSE