Somisetty Gowtham Kumar
Bangalore
Summary
- Project Engineer with 3 years of IT experience in design, development, implementing innovative performance driven ETL solutions & testing of reporting applications and databases for large scale enterprises.
- Comprehensive knowledge on a wide variety of technologies like Informatica Power Center, Teradata, MySQL, Control-M scheduling software, IICS, Big Query and basic knowledge on UNIX.
- Quality driven and hardworking professional well-versed in industry best practices, project development and support.
- Full exposure to Software development life cycle from requirement gathering to implementing, testing and problem solving by collaborating with various teams such as Admin, Production Support, Quality Assurance.
- Good communication skills, self-motivated, quick learner, team player.
- Skills in conducting system analysis, data investigation, design & testing of reporting databases.
- Working in Agile process and experienced in handling team.
- IICS Associate certified and GCP Associate certified in 2023
Overview
3
3
years of professional experience
Work History
Project Engineer
WIPRO
08.2021 - Current
- Designing and creating ETL flows for different source systems to load data into IDW (Integrated data Warehouse) as well as CDW (Cloud data Warehouse) system.
- Designing the data flow diagram and approach to be followed in order to meet requirements.
- Worked on building ETL solution using Informatica Power Center for development of dependent data mart & data warehouse by collecting data from various in-house sources & enterprise-wide data warehouse like RPS, ABI, Salesforce, and others.
- Created Databases/tables in Teradata in different format and layers to inculcate data.
- Created ESP/Control-M application for scheduling Informatica jobs.
- Hands on experience on BTEQ/shell scripting along with Teradata/SQL/SQL server db.
- Leading development of reporting-based Data Warehouse and in design, review, implementation & optimization of Extract, Transform & Load (ETL) processes. Worked on performance tuning and troubleshooting issues as and when required.
- Coordinated with Business Analysts to translate business requirements into technical user specifications, including data, process & interface specifications and conducted feasibility study.
- Proactively monitored the overall system from the data load perspective and took appropriate actions to improve the overall implementation. Peer review and quality checks before customer delivery. Actively listened to customers to fully understand requests and address concerns.
Education
Bachelor of Technology - Computer Science And Engineering
QIS Institute Of Technology
Ongole, India07.2021
Intermediate -
Sri Chaithanya Junior College
Vijayawada, India04.2017
10th Standard -
Apex Techno School
Ongole, India04.2015
Skills
- ETL Tools: Informatica Power Center, IICS
- Database Platforms: Teradata, MySQL, Big Query
- Scheduling tools: Control-M
- Software & tools: JIRA, Confluence, Bitbucket, GITHUB & Bamboo
Timeline
Project Engineer
WIPRO
08.2021 - Current
Bachelor of Technology - Computer Science And Engineering
QIS Institute Of Technology
Intermediate -
Sri Chaithanya Junior College
10th Standard -
Apex Techno School
Similar Profiles
Nedunchezhian SundaramoorthyNedunchezhian Sundaramoorthy
Architect at WiproArchitect at Wipro
Rajesh JoshiRajesh Joshi
Us mortgage Underwriter at WiproUs mortgage Underwriter at Wipro
Vaibhav VashisthaVaibhav Vashistha
Senior Analyst at WiproSenior Analyst at Wipro
Brogan DohertyBrogan Doherty
Executive Assistant at WiproExecutive Assistant at Wipro
Naveen Kumar Reddy BandreNaveen Kumar Reddy Bandre
Staff Technical Program Manager at Trellix Software India Private Limited (Formerly McAfee), BangaloreStaff Technical Program Manager at Trellix Software India Private Limited (Formerly McAfee), Bangalore