Client Business Domain: Manufacturing & LogisticsJob Duty:• Engaging with Business Stakeholders and the Data Architecture Management Office Team to facilitate the designing of architecture for fulfilling the data modernization requirements• Proposing the best possible solution approach using Data Vault 2.0 through Raw Vault, Pit/Bridge Tables, and Information Delivery layer to hold the historical transactions effectively and efficiently.• Working on the Dimensional Model to best fit the reporting and auditing requirements.• Investigating multiple sources through data profiling to come up with scalable and consistent architecture meeting the needs of the enterprise.

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:· Design architecture for technology solutions that fulfill business requirements and align with the best practices· Understand business and functional requirements and provide solutions to meet the requirements· Creating high and low-level design documents and leading the architectural discussions to finalize a final design· Design Data Ingestion flow from (Data Lake) Amazon S3 to Raw Vault and finally to Information Layer (Snowflake) via Business Hub using Data Vault 2.0.· Creating the Fact Dimensional modeling in the consumption layer to make the data available for consumption by the reporting tools.· Creating Data reconciliation framework for each data hop and meeting the SOX regulation standards· Creating the logical and physical data model in the erwin data modeller to show the data vault layer following the Satellite Hub link modeling techniques and the dimensional model components· Creating data governance framework and work with the teams to fulfill all the guidelines and templates to execute the same.· Design and build view-based Semantic layer with row level/column level security in Snowflake for data consumption.· Design reporting framework based on the semantic layers and reporting requirements.· Upload data lineage and / Data Concept / Glossary Term Update in Informatica Axon.· Using Data Vault 2.0 model, worked to model RAW Vault/Information layer to capture historical data from multiple different sources designed to be resilient to environmental changes and proposed a flexible, scalable, adaptable, and consistent model meeting the enterprise standards

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:• Engage in working sessions to study and understand existing business processes, IT system features, pain areas, and expectation from future cloud-based IT systems for client's emerging Lines of Businesses in presence of respective Business Product Owner, Technical Product Owner and other stakeholders.• Design Enterprise Data Lake using Data Vault 2.0 data modeling standards to support client's Multi Tenancy Enterprise Data Platform, the data supply chain product in cloud.• Design and develop domain based Dimensional data models (Conceptual, Logical and Physical models) to support holistic data consumption requirements from the new Enterprise Data Warehouse (EDW) instead of Business Unit specific Data Marts to avoid data silos and data redundancies.• Design of Data Pipeline using Snowflake Database, SnowSQL queries, Snowflake Stored Procedures and Amazon Web Services as platform.• Drive design solutions for large-scale data migration from on-premises (Netezza) to cloud platform (Snowflake) with process optimization and scalability of efforts.• Create Event Driven Data Ingestion Framework, Data Quality and Data Security framework.• Create coding standards and best practices for data pipelines for the teams to use so that all logs, data capture and codes are in sync across different teams.

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:- Enterprise Data Warehouse and Business centric Data Mart design- Data Modeling using ErWin modeling tool- ETL (Informatica, Netezza and Oracle Stored Procedure) code development for Data Management processes- Leading end-to-end technical product delivery- Client facing and daily interaction- Coordination between On-shore and Off-shore delivery team

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:• Understood the Business user requirements & data profiling.• Coordinated with on-site and offshore data, report and QA teams to explain technical designs and collaborated to develop final codebase as per approved design and automated framework approaches.• Involved in Design, development and testing of the codes to fulfill the data need.• Prepared design document, traceability matrix, test cases and test results.• Developed the ETL components in Informatica PowerCenter and new tables and Stored Procedures in Netezza.• Prepared the Job scheduling plan and executed through Autosys job scheduler.• Collaborated with report developer and data engineers to design the Report Semantic Layer to support enterprise/self-service reporting platform.• Provided Post post-implementation support after implementation of the project.• Worked with Business Data Stewards to identify the KPIs for all the pipelines to maintain the data accuracy and completeness for internal and external audit purposes.• Discussed with Business Stakeholders to give them a walkthrough of the functionality of the reports.

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:• Design data pipelines to consume data across Staging, Hub, and Mart layers in On-Prem Netezza Data Warehouse to meet the different functional requirements.• Design physical and logical data models for data consumption in the data Mart layer• As a technical lead, completed End-to-end project implementation for multiple enterprise initiatives.• Understand the data and reporting requirements from different LOB(s) and craft a solution approach to meet the requirements from a data & reporting perspective.• Create high-level design documents that aligns with the organization’s architectural policies and get the necessary approvals

Client Business Domain: Banking, Financial Services & InsuranceJob Duty:• Participated in conversations with business users, understanding business processes and requirements conduct proof of concept using cloud technologies and services.• Involved in Data Analysis and Profiling of data to understand data patterns, nature and quality of data which are pre-requisite of data model and design activities.• Designed of dimensional data model (logical/physical) to manage the analytical data for analytical and reporting users.• Prepared technical design document, data mapping documents, data flow diagram etc.• Designed Autosys jobs for automated job scheduling.• Performed unit testing of the ETL processes using Informatica PowerCenter 9.x and 10.x.• Coordinated with QA team to capture business and technical scenarios for robust test case and planning.• Performed peer review of the technical deliverables to ensure correctness, completeness and standards of deliverables.• Provided warranty support after implementation of the projects.• Conducted demo sessions with Business Users, and client's leadership team to walk-through the features and functionalities of the deployed technical products.• Deployed code changes across all environments using versioning systems like GIT Hub.