Working as etl developer with SQL as db

Revenue bsed project

Communicate with BA team to understand the requirement.Provide estimates for the assigned tasks and responsible for on time deliverables.Created various Transformations like Lookup, Joiner, Aggregate, Filter, Expression, Router, and Update StrategyPrepare Mapping docs as per the business requirement.Created Informatica mappings, sessions, workflows & scheduling of session for loading dataDevelopment and support for maintenance and enhancement tasks.Responsible for Job monitoring/Production support.Involved in preparation of test cases and testing of mappingCode review and unit testing should be done before deploying the code from Dev to QA environment.

Anthem Inc. is an American health insurance company founded in the 1940s, prior to 2014 known as WellPoint, Inc. This project was to create a staging warehouse for providers data using multiple techniques. As initially providers data was not updated & we are doing it with the help of techniques like Type1 implementation, Soft delete & Org split. Providers data comprised of hospitals, doctors & beneficiaries. The purpose statement of Anthem states that Together, we are transforming health care with trusted and caring solutions & to be Americas valued health partner. This project was to create analytical information and generate reports which help to improve their services in providing the best policies for the customers. It involved importing the data and then exporting it to downstream systems, managing different teams as well as fetching the data from ODS. Worked on Universal Application which has a layered structure. Although the combination of layers constitutes a Tenfold Application, additional objects can surround an application as well.