• Creating data-lakes using MarkLogic (No-SQL Enterprise Database), Data Hub framework, JavaScript & XQuery

• Experienced in Data analysis using query languages like SQL, JavaScript and Python

• Integrating the data from different databases (Oracle, SQL Server etc.) and sources (Legacy,CSV,XML,JSON,TEXT,Binary etc.) and bring them in MarkLogic.

• Expert in setting up the Data Warehousing, ETL and BI Architecture

• Creating relevant data artifacts/models to support the Enterprise Architecture Review Board, which is a governing body for reviewing and approving all the ETL/Data architectures in the organization.

• Leading the development of mappings/workflows/sessions/Scripts for the ETL/Data Quality process using Informatica Suite( Powercenter, Informatica Data Quality, Data Analyst)

• Visualizing the data using BI tools like OBIEE and Tableau.

• Experienced in the Healthcare domain (Providers, Claims, Members etc.)

• Experienced in Data Modeling while working as a Data Architect to analyze and discover key business domains and processes.

• Experience in Amazon Web Services (AWS) and working on cloud based solution for the enterprise architecture of Provider domain

• Collaborated with client and business analysis team members to define, enhance and develop Analytical data marts

• Designing and developing Complex ETL mappings using Informatica Designer, and configuring sessions/workflows using Workflow Manager

• Designing/creating/managing data quality architecture (Profiling, rules etc.) using Informatica Data Quality (IDQ) and Informatica Analyst.

• Designed, developed and implemented solutions to support new product concepts at the same time modifying and expanding existing product functionality to improve data quality

• Visualized data using multiple BI tools like Salesforce analytics cloud wave (BI Cloud) and OBIEE.

• Analysed data using SQL, SAQL and PIG query languages

• Performing and leading activities like Error Handling, Scheduling, Identifying ETL Job Dependency and Recovery mechanisms

• Resolved customer issues by establishing workarounds and solutions and by debugging and creating defect fixes

• Led a team of 6 members in development ,testing and deployment phases of the project.