Summary
Overview
Work History
Education
Skills
Accomplishments
Disclaimer
Personal Information
Timeline
Generic

Sowmya S

Sr. ETL Developer
Chennai, Bangalore

Summary

  • Experienced Business Intelligence professional with 7.11 years of expertise in developing large-scale Data Warehouse and Client/Server Applications using Informatica PowerCenter, Teradata, and IBM DB2.
  • Skilled in gathering business requirements, design, and analysis for project enhancements.
  • Proficient in Agile and SDLC methodologies, with hands-on experience in ETL processes using Informatica PowerCenter.
  • Expertise includes building Informatica mappings, data transformation, conversion, loading, and data analysis.
  • Familiar with DevOps tools such as Git, Bitbucket, and Bamboo for CICD pipeline execution.
  • Capable of designing queries and scripts, conducting end-to-end testing, defect logging, and identifying requirement gaps.
  • Experienced in scheduling jobs using Control-M scheduling tool. Seeking a progressive employer to contribute to the achievement of company objectives.

Overview

8
8
years of professional experience

Work History

Sr.Software Engineer

Carelon Global Solutions
06.2019 - Current
  • Collaborated with cross-functional teams to design innovative software solutions.
  • Proactively identified areas for process improvement, implementing changes that led to significant time savings for the team.
  • Created proofs of concept for innovative new solutions.
  • Demonstrated significant commitment on delivering complex user stories.
  • Delivered assigned projects on time with characterized quality measures incorporates analysis of the existing flow,regression testing for the impacted components.
  • Involved in developing an BTEQ script to pull out claims from Source (Teradata) and load it to DB2 tables (target).
  • Developed Standalone process, Created CTM scheduled job to have a trigger base approach thus avoided manual execution.
  • Handling the ad hoc requests for ETL changes, applied break fix in case of Production failure.
  • Involved in Creating Unit test plans, test case documents, performing unit testing, and mock Quality Assurance Testing on ETL Mappings and Workflows. Reviewed the test cases in hardening phase. (UAT testing)
  • Scheduled and Monitored jobs using Control-M scheduling tool.
  • Raised Upstream issue to the Source team, and actively involved in all the discussions with business.
  • Rising/closing defects, executing test cases and creating decks for status purpose in JIRA.
  • Involved in giving internal and external reviews to the client.
  • Acted as Scrum master at times, managed the scrum boards and backlogs effectively.
  • Actively built a strong rapport with business after the transition period.
  • Been Part of Devops team to build the CICD pipeline for the project using Bitbucket & Bamboo.
  • Mentored junior developers, fostering professional growth and enhancing team productivity.

Informatica Etl Developer

Accenture Solutions Pvt Ltd
06.2017 - 04.2019
  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer.
  • Developed IDW (Integration Data warehouse) Teradata - Target database from different sources like Oracle, SQL Server, XML and Flat files. This IDW is used up by business for analytical purpose to generate reports.
  • Responsible for performance tuning ETL process to optimize load and query Performance.
  • Extracted data from various source systems like Oracle, SQL Server, XML, and flat files and loaded into relational data warehouse and flat files.
  • Actively Involved in Production defect analysis and Production data validation.
  • Experience in writing basic UNIX Shell Scripts for Informatica.
  • Tracking the task status on JIRA.
  • Strong knowledge in RDBMS concepts, Data Modelling (Facts and Dimensions, Star/Snowflake Schemas), Data Migration, Data Cleansing and ETL Processes.
  • Involved in creation of batch scripts for ETL audit.
  • Handled ETL Audit and Exception tables along with ETL standards.
  • Involved in the code review and buddy testing of ETL objects.

Education

Bachelor of Engineering - Computer Science

Panimalar Engineering College
Chennai
01-2017

Skills

  • Informatica PowerCenter expertise

  • SAS Programming

  • GIT

  • Power BI

  • Agile methodologies expert

  • CONTROL-M

  • BTEQ Scripting

  • SQL/PL SQL

  • Informatica PowerCenter expertise

Accomplishments

  • Awarded Annual Team Excellence (Best Performer) Award 2019 for HIX in Legato.
  • Awarded Accountability warrior in Legato for demonstrating end to end ownership and accountability on Anthem CMS ACA Act 2020 Submissions.
  • Awarded IMPACT award by Anthem.
  • Managed a team of 15 employees, ensuring that a $70000 budgeted project was completed by the expected deadline.
  • Received reward points from business directly for completing complex stories.


Disclaimer

I hereby declare that all the information contained in this resume is in accordance with facts or truths to my knowledge. I take full responsibility for the correctness of the said information.

Personal Information

  • Father's Name: Sridharan D
  • Date of Birth: 02/03/96

Timeline

Sr.Software Engineer

Carelon Global Solutions
06.2019 - Current

Informatica Etl Developer

Accenture Solutions Pvt Ltd
06.2017 - 04.2019

Bachelor of Engineering - Computer Science

Panimalar Engineering College

Similar Profiles

CREATE PROFILE
Sowmya SSr. ETL Developer