Hamsini Poovamma B S profile photo 1 on Tal

Hamsini Poovamma B S

ETL Developer | Data Engineer | BI & DWH | GoogleCloudCertified

Bengaluru

10+ years of work experience

Carelon Global Solutions India
Oct 20241 yr 8 mosPresent

Bengaluru, Karnataka, India · Hybrid

Carelon Global Solutions India
Aug 20213 yrs 3 mosOct 2024

Bengaluru, Karnataka, India · Hybrid

Tech Mahindra
Dec 20164 yrs 9 mosAug 2021

Bengaluru, Karnataka, India

• Demonstrated strength in SQL, data modeling, ETL development, and data warehousing • Worked extensively on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability. • Built databases and table structures as per business requirements. • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process. • Implemented BI solution framework for end-to-end business intelligence projects. • Created and implemented database designs and data models. • Wrote and maintained technical and functional specifications to document database intentions and requirements. • Designed and created ETL code installations, aiding in transitions from one data warehouse to another. • Wrote and optimized in-application SQL statements. • Interpreted data models for conversion into ETL diagrams and code. • Managed data quality issues during ETL processes along wit • Designed and developed Informatica Mappings (Type1 and Type2) and Sessions based on business user requirements and business rules to load data from source flat files and oracle table to target tables and flat files. • Designed and implemented stored procedures, views and database tables to be used in the mappings • Created and monitored sessions using workflow manager and workflow monitor. • Designed Control m jobs that automated the execution of Informatica jobs.
Tech Mahindra
Aug 20164 mosNov 2016

Bangalore

Education

Bachelor of Engineering (B.E.), Electronics and Communication

BMS Institute of technology

20124 yrs2016

Join Hamsini and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Hamsini Poovamma B S on Tal

Headline

ETL Developer | Data Engineer | BI & DWH | GoogleCloudCertified

About

Software Engineer with a demonstrated history of working in the information technology and services industry. Dependable ETL Developer with 9 years of experience in creating reliable and accurate data transformation tools. Well-versed in technologies such as Informatica, Oracle PLSQL, Teradata, AWS, Snowflake and Python. Involving in various projects related to Data Modeling, Data Analysis, Design and Development for Data Warehousing environments. Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation and data migration. Exceptional troubleshooting skills with ETL technologies.

Location

Bengaluru

Work experience

Senior Software Engineer at Carelon Global Solutions India, Oct 2024 - Present · 1 yr 8 mos, Bengaluru, Karnataka, India · Hybrid

Software Engineer at Carelon Global Solutions India, Aug 2021 - Oct 2024 · 3 yrs 3 mos, Bengaluru, Karnataka, India · Hybrid

Data Engineer/ETL Developer at Tech Mahindra, Dec 2016 - Aug 2021 · 4 yrs 9 mos, Bengaluru, Karnataka, India, • Demonstrated strength in SQL, data modeling, ETL development, and data warehousing • Worked extensively on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability. • Built databases and table structures as per business requirements. • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process. • Implemented BI solution framework for end-to-end business intelligence projects. • Created and implemented database designs and data models. • Wrote and maintained technical and functional specifications to document database intentions and requirements. • Designed and created ETL code installations, aiding in transitions from one data warehouse to another. • Wrote and optimized in-application SQL statements. • Interpreted data models for conversion into ETL diagrams and code. • Managed data quality issues during ETL processes along wit • Designed and developed Informatica Mappings (Type1 and Type2) and Sessions based on business user requirements and business rules to load data from source flat files and oracle table to target tables and flat files. • Designed and implemented stored procedures, views and database tables to be used in the mappings • Created and monitored sessions using workflow manager and workflow monitor. • Designed Control m jobs that automated the execution of Informatica jobs.

Associate Software Engineer at Tech Mahindra, Aug 2016 - Nov 2016 · 4 mos, Bangalore

Education

Bachelor of Engineering (B.E.), Electronics and Communication, BMS Institute of technology

Hamsini Poovamma B S - Senior Software Engineer in Bengaluru | Tal