Revathi Rai G R

• Associated with Centene Corporation, which is one of the largest Medicaid managed care organizations in the U.S.
• Worked as a Data Analyst using SQL and expertise in writing SQL queries, creating stored procedures, and analyzing the mappings in Informatica PowerCenter.
• Experience in working with Oracle, Teradata, and Snowflake databases, and ETL tools, Informatica PowerCenter.
• Analyzed data using SQL to support decision-making processes at Centene Corporation.

Projects

Centene EDW enhancement dev T:

1. It's a data warehousing project where our team is responsible for modifying the source data and loading data to target tables for the reporting teams..

2. My role in the project is as an analyst.

3. Validated the data using SQL and Informatica PowerCenter to check whether it was loaded to the target tables correctly.

4. Create user-defined functions that will be used in select queries while creating views on source tables.

Snowflake Decomm Project:

1. Worked on the issues raised by reporting team and identify the root cause by checking etl script which loading data to target tables.

2. Update the mapping document for tabes and fields which are not matching with etl logic in the script.

3.Created Jira for respective development with the correct resolution document after checking with data modelling team.