Sahithi Dungala
Bangalore
Summary
- Having 9+ years of Experience on Warehousing in analysis, design, and development of software applications using Informatica.
- Meticulous SQL Developer with expertise in processing data and knowledge of various flowcharting techniques. An excellent understanding of database structures, theories, principles, and practices. Superb problem-solving and analytical skills.
- Having strong conceptual knowledge in Data Warehousing, extensively used ETL methodology for supporting Data Extraction, Transformations & Loading process, in a corporate-wide-ETL Solution.
- Expertise with ETL processes utilizing Informatica Power Center to design data conversions from a variety of relational, flat file source systems to data marts/EDW.
- Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Lead SQL Developer
EMIDS Technologies Pvt. Ltd.
Bangalore
03.2022 - Current
- Provided technical assistance in the form of SQL coding advice to other team members.
- Developed stored procedures, functions and triggers to support application requirements.
- Integrated multiple data sources into one unified view using views or joins in SQL queries.
- Analyzed business requirements and translated them into logical data models.
- Utilized version control systems to manage changes to SQL scripts and database objects, ensuring consistency across environments.
- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.
- Optimized SQL queries and stored procedures, reducing execution time by significant percentages.
ETL Informatica Developer|| SQL Developer
Cognizant Technology solutions
11.2014 - 03.2022
- Developed ETL process to extract, transform and load data from Oracle database into the Data Warehouse using Informatica PowerCenter.
- Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
- Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
- Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
- Developed shell scripts to schedule the execution of ETL jobs through Cron scheduler on UNIX platform.
- Used Performance tuning techniques such as Partitioning technique and Bulk Loader options available within Transformations section while developing Mapping logic .
- Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
- Designed complex reports using SQL Server Reporting Services.
- Developed stored procedures, functions and triggers to support application requirements.
Education
B.Tech in Electronics and Computer Engineering -
KLUniversity
Skills
- Microsoft Azure
- Informatica Power Center
- UNIX Scripting
- Microsoft SQL Server Management studio
- RDBMS: Oracle/PLSQL, DB2
- ETL Tools: Informatica Power Center 9x/101, Tableau 90
- Reporting Tools: SSRS 2008R2, SSRS 2018
- Domain: Healthcare, Manufacturing, Retail & Travel Group, Insurance
- Operating System: Windows,Linux
Accomplishments
- 'STAR AWARD' - Inclusive Innovators was awarded in Elevate'24 in EMIDS
Certification
- Azure fundamentals certificate was completed.
Languages
English
First Language
Projects
- WDPR - Walt Disney Park and Resorts(2014-2015)- SSIS and Tableau Developer
- Wyndham Hotel Group (2017-2019) - Informatica and SQL developer
- Mercury Insurance (2019-2020) - Informatica and SQL Developer
- CareFirst - BCBS(2020-2022) - Informatica and SQL Developers
- NHPRI - Dev Services(2022- Present)- MSSQL Developer
Tools
- Microsoft SQL Server
- Informatica power center
- Unix
- Oracle 19c
- Mapforce
- JIRA
- Active Batch
- Jenkins
- DB2,Postgress SQL
- Tableau
- POWER BI
- Excel
Timeline
Lead SQL Developer
EMIDS Technologies Pvt. Ltd.
03.2022 - Current
ETL Informatica Developer|| SQL Developer
Cognizant Technology solutions
11.2014 - 03.2022
B.Tech in Electronics and Computer Engineering -
KLUniversity
- Azure fundamentals certificate was completed.
Similar Profiles
Pavithra DCPavithra DC
Senior Business Analyst/Product Owner at EMIDS TECHNOLOGIES PVT. LTD.Senior Business Analyst/Product Owner at EMIDS TECHNOLOGIES PVT. LTD.
Krishna DKrishna D
Senior Manager - Finance at Emids Technologies Pvt. LtdSenior Manager - Finance at Emids Technologies Pvt. Ltd
Aswathi MKAswathi MK
Senior Test Engineer at Emids Technologies Pvt. Ltd.Senior Test Engineer at Emids Technologies Pvt. Ltd.