Soujanya G.
ETL Developer at Cigna Health Spring- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Cigna Health Spring
-
United States
-
100 - 200 Employee
-
ETL Developer
-
Jun 2019 - Present
The primary objective of this project is to capture different customers Med/Pharmacy claims, policies, products and Financial related data from Multiple OLTP systems and flat files. Extracted, Transformed and loaded data into data warehouse using Informatica Power center. End data is sent to Optum for generating reports for business analysis. The primary objective of this project is to capture different customers Med/Pharmacy claims, policies, products and Financial related data from Multiple OLTP systems and flat files. Extracted, Transformed and loaded data into data warehouse using Informatica Power center. End data is sent to Optum for generating reports for business analysis.
-
-
-
CIBC
-
Canada
-
Banking
-
700 & Above Employee
-
ETL Developer
-
Jul 2014 - Oct 2017
Fraud System Replacement project deals with fraud data and loads this data into different tables upon certain rules. Jobs migrated from DataStage to Informatica Power Center. Resultant data is sent to downstream for contacting the customers. Fraud System Replacement project deals with fraud data and loads this data into different tables upon certain rules. Jobs migrated from DataStage to Informatica Power Center. Resultant data is sent to downstream for contacting the customers.
-
-
-
Bharat Sanchar Nigam Limited
-
Telecommunications
-
700 & Above Employee
-
Information Technology Associate
-
Jan 2014 - Jun 2014
This system acts as a third party to those users who wish to use the resources through Internet. This will help by giving some screens and check the data and it will give the different messages. This system acts as a third party to those users who wish to use the resources through Internet. This will help by giving some screens and check the data and it will give the different messages.
-
-
Education
-
Kennesaw State University
Masters, Data Science -
JNTUH College of Engineering Hyderabad
Bachelor of Technology - BTech, Computer Science