To perform data ingestion and data analysis and Data masking. Building source of truth master data layer

Building DataMart for several source system by Delta load, generate extracts in S3 Datalake, Designing Datamodels using MS Visio, IDERA and ER Studio. Data profiling using python and excel macros.

Batch processing for loading customer data in Back end to facilitate front end

Using Informatica Power Center as an ETL tool to build EDW architecture on top of core banking factual data, also used as batch processing of multiple user data across different service vendors and banking partners. Separate job module for VISA and Mastercard to process the fact details across the globe and use the same for facilitating the backend of its web services and applications. Shell scripting to automate job scheduling, Pentaho kettle to articulate key extraction of records.

Building EDW to generate reports

Using Informatica Power Center to establish and implement DWH architectural solution by loading and maintaining DataMarts and Incremental loads on a Bi weekly basis. Using Procedures to perform the error handling by working along with Informatica Data Quality (IDQ). The EDW is consumed by the OBiEE reporting team which will be used by the end user.

Building Financial reports against claims . Building ad-hoc reports

US Health Care system, using Informatica Power Center as an ETL tool to build on the enterprise level Data Stalmarts and EDW. Insurance claims data across different policies are incrementally aggregated based on each subscription level. Claims data financial calculations are aggregated and incrementally loaded.

Building EDW by generating data marts

US Health Care system, using Informatica Power Center as an ETL tool to build on the enterprise level Data Stalmarts and EDW. Insurance claims data across different policies are incrementally aggregated based on each subscription level.