Architect and Solution Design for building a Data Warehouse within client premise which includes in selection of Tools, Technologies, Data Strategy and Data Security.Data Profiling, data analysis and data quality for better understanding of source systems data. Participated in regular Design and Technical Reviews and walkthrough meetings with important project & business stakeholders throughout the project life cycle.Designed and Modelled (Conceptual, Logical and Physical) data based on ECDM (Enterprise Conceptual Data Model) for Integrating the different source systems data based on each subject area.Design acquisition patterns of data from disparate systems - Systems of Record which are hosted respectively at different vendors for both Historical and Incremental data loads.Designed Automated tools for Ingestion to support different disparate datasets and for Integration using Metadata Driven and Query Driven approach.Data Governance and data management which includes metadata management using Abinitio Metadata HUB, Collibra which includes Business and Technical metadata, data quality, data profiling, data lineage. Build Data Migration strategy, Data Mapping and transformation rules.Design and built Data Virtualization strategy using Composite software.Designed Automated tools for Ingestion to support different disparate datasets and for Integration using Metadata Driven and Query Driven approach.

Solution Designer for building a Data Warehouse, data profiling and creating the mapping documents by reverse engineering from application to different disparate source systems.Data Modelling (conceptual, logical and physical) for future state aligning to the standards and Business requirements related to OLTP and OLAP.Data profiling, analysis of the source systems and creating data mapping documents and business logic for implementing the target data warehouse. Building Entity Relationship Diagram using data files for better understanding of the source systems. Participate in the end-to-end design, review, implementation, and maintenance of enterprise technology, information, and business architectures. Build ETL graphs using Informatica (mappings, sessions and workflows) and OWB.Administer oracle database and tune database activities. optimizing existing PL/SQL code, tuning SQL queries, customization and debugging of the code.