Summary
Overview
Work History
Education
Skills
Skillssummary
Timeline
Generic

Kura Soumya

Hyderabad

Summary

  • Experience Summary
  • 5+ years of IT experience
  • 2+ years of experience in Analysis, Design, Implementation, Testing and Support of data Warehousing and Data Integration solutions using Informatica PowerCenter.
  • 1+ years of experience in using reporting tools such as SSRS.
  • Proficiency in developing SQL with various databases like Oracle and SQL Server.
  • Knowledge in Full Life Cycle development.
  • Have extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading using Informatica Power center.
  • Understand the business rules completely based on High Level document specifications and implement the data transform methodologies.
  • Independently perform complex trouble shooting, root-cause analysis and solution development.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
  • Team Player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
  • Comprehensive technical, Oral, written and communicational skills.

Overview

5
5
years of professional experience

Work History

Senior Data Engineer

Johnson and Johnson
08.2022 - Current
  • Understanding the client's business functionality
  • Involved in understanding the sources, targets, transformed the data, mapped the data and loading the data into targets using Informatica
  • Developed Parameter file generation mapping
  • Developed Several mappings as a part of enhancement where we have added multiple columns for specific tables and brought the resulted outcome from STG level to DWH level
  • Involved in preparing review check list as per coding standards
  • Involved code deployment from DEV to DWH
  • 24/7 production support for multiple applications within J & J
  • Monitored the jobs in Control-M application
  • Worked in SQL support for BWI Application
  • Monitored Jobs for BWI application in SSMS portal and triggered the reports using SSRS portal.
  • On-site and Offshore team coordination

LTIMindtree
06.2022 - Current

Amazon
08.2019 - 06.2022

Transportation Specialist

Amazon
Hyderabad
08.2019 - 06.2022
  • Communication with external customers (Carriers, Vendors/Suppliers) and internal customers (Retail, Finance, Software Support, Fulfillment Centers)
  • Ability to pull data from numerous databases (using Excel, Access, SQL and/or other data management systems) and to perform ad hoc reporting and analysis as needed is a plus
  • Develop and/or understand performance metrics to assist with driving business results
  • Ability to scope out business and functional requirements for the Amazon technology teams who create and enhance the software systems and tools are used by TOC
  • Must be able to quickly understand the business impact of the trends and make decisions that make sense based on available data
  • Must be able to systematically escalate problems or variance in the information and data to the relevant owners and teams and follow through on the resolutions to ensure they are delivered
  • Work within various time constraints to meet critical business needs, while measuring and identifying activities performed
  • Excellent communication, both verbal and written as one may be required to create a narrative outlining weekly findings and the variances to goals, and present these finding in a review forum
  • Providing real-time customer experience by working in 24/7 operating environment

Education

Bachelors in Information Technology (B.Tech) -

01.2019

Skills

  • SQL
  • ETL Informatica PowerCenter 1051
  • SSMS
  • SSRS
  • Oracle SQL
  • ADF (Azure Data Factory) Basics
  • IICS Basics

Skillssummary

 SQL, Informatica PowerCenter 10.5.1, SSMS, SSRS, Oracle SQL, Toad, ADF (Azure Data Factory) Basics, IICS Basics

Timeline

Senior Data Engineer

Johnson and Johnson
08.2022 - Current

LTIMindtree
06.2022 - Current

Amazon
08.2019 - 06.2022

Transportation Specialist

Amazon
08.2019 - 06.2022

Bachelors in Information Technology (B.Tech) -

Similar Profiles

CREATE PROFILE
Kura Soumya