• Expert as Data Analyst, Data Warehouse Solution Architect, Data modeling, Data Architect.• Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.• Excellent working Experience on Azure Resources like Azure Data Factory, Azure Synapse Analytics (previously Azure Data Warehouse), Azure Databricks, Azure Storage.• Experience in Developing Notebooks using Azure Databricks, SparkSQL and Python.• Architect solutions using MS Azure PaaS services such as Azure Synapse, Azure Databricks, SQL Server, HDInsight etc.

• Expert as Data Analyst, Data Warehouse Solution Architect, Data modeling, Data Architect.• Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.• Excellent working Experience on Azure Resources like Azure Data Factory, Azure Synapse Analytics (previously Azure Data Warehouse), Azure Databricks, Azure Storage.• Experience in Developing Notebooks using Azure Databricks, SparkSQL and Python.• Architect solutions using MS Azure PaaS services such as Azure Synapse, Azure Databricks, SQL Server, HDInsight etc.• Provide technical oversight and guidance during client’s engagement execution.• In Depth Knowledge in both Multidimensional and Relational Modeling.• Experience in Architecting Data Warehouse and Extraction, Transformation, and Loading (ETL&ELT) process for complex business that gets data from various sources into Data Warehouse and designing Data Marts out of warehouse.• Architected data warehouse from requirements gathering to conceptualization to creation of data marts using Data Vault, Inmon and Kimball methodologies.• Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality and Data Governance.• In-depth knowledge of development and design with RDBMS -OLTP, dimensional modelling using data modelling tool ERWIN, TOAD, SQL Developer.• Experience with Agile development - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, ETL development, Unit and System Testing.• Good team player, motivate team members, visionary, good planner, mitigate risk, strong analytical and presentation skills.

Responsibilities: • Develops partnerships and works closely with business team members to understand and document day in the life and usability requirements through storyboards, wireframes, user interface specifications and other documentation. • Create integration context diagrams and associated systems process models to aid in clarity • Work closely with Business functional analyst and business customer to ensure information and integration requirements are clearly understood and resolve any conflicts• Create and maintain Paper prototypes, UI storyboards and UI Specifications by working closely with Functional Analysts and Business team members. • Defines test scenarios based on business processes and may participate in Integration Testing when needed. • Conduct usability User Acceptance Tests with business teams.• Designed Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.• Create /Review Test Plans for Unit / Integration testing.• Identify/resolve bugs when developers are not able to do so.• For small duration, worked with Nike business using Informatica Metadata manager and Business glossary in creating the enterprise wide data linkage between Business terms and end database object.• Troubleshoot and diagnose ETL performance issues, Performance tuning and query optimization.• Managed the overall Data model/ETL/Reports deliverables.

• Involved in Requirement gathering, Logical and Physical Data model design. • Extensively worked to analyze and identify source systems, design data structures, data selection, data integration, Data profiling and resolve data quality issues.• Head complex ETL requirements and design. Developed solution in highly demanding environment and provide hands on guidance to other team members.• Clearly defined the Scope and Assumption of Interfaces, Communicated the Risk and Mitigation plans proactively to Business Stakeholders.• Design Test Plans for Unit and Integration test.• Optimized/Tuned the existing Informatica mapping in various levels by avoiding bottleneck to get better performance without disturbing the existing system functionalities.• Involve streamlining in loading huge volume of data from source to target. • Worked in integrating with Salesforce, and other third party server/application like Webserver, BO, Tivoli etc. through Informatica server.• Loading and extraction data from Salesforce.com (cloud technology) using Informatica 9.1.

• Worked as Datastage Administration and ETL development Lead• Datastage server health check, patch/ fix pack installation, resolving unknown/new issue.• Involve in creating Source to Target mapping by studying the specifications and analyzing the required transforms.• Work as Lead and complete owner to Migrated 7.5 jobs to Datastage 8.1.• Optimized/Tuned the existing Datastage jobs in various levels by avoiding bottleneck to get better performance without disturbing the existing system functionalities.• Audit Log database of unsuccessful records that failed to be created or updated with appropriate reasons.• Coaching and mentoring staff developers.

• As Onsite Technical Lead, interacted with Business Users / Analysts to understand the requirements and translate the requirements to technical specifications ETL Mappings in Informatica. • Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.• Managing/Coordinating the Enhancement releases from requirement gathering, Design, Development, System testing, QA and Production deployment between teams.• Involved in performance tuning in various level of ETL mappings.• Drafted Test Plans, Back out plans and Contingency measures during the Production Patches/Fixes for the existing applications.• Developed UNIX Shell scripts for scheduling the jobs.• Developed project related documentation, participated in testing, performance tuning, business meetings and other activities as required by project

• Analysis and designing of ETL processes.• Involved in preparing Logical and Physical data model, Source Data Analysis, ETL Process flow and the schema objects with necessary Indexes, Partitions.• Designed the jobs based on the understanding the Data model table relationship.• Optimized/Tuned the existing Informatica mapping in various level (Source Qualifier, Transformations and Target) by avoiding bottleneck to get better performance without disturbing the existing system functionalities. • Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces

• Created, maintained the Logical/Physical data models.• Designed Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.• Design Informatica mapping and session template for various phase of projects.• Work and supported the ETL developer during project’s build and System test and UAT phase.• Design Test Plans for Unit and Integration testing.• Reviewed and randomly tested Informatica coding.• Troubleshoot and diagnose ETL performance issues, Performance tuning and query optimization.• Managed the overall Data model/ETL/Reports deliverables.

• Analyze the external third party vendor sources (SSB/Fact set etc) to establish feeds into Data Warehouse.• Analyze the existing systems used by different users and establish the feeds to these systems from Data Warehouse.• Create session tasks for each mappings and workflows to run the sessions using Informatica Workflow Manager. Monitor scheduled and running workflows using Workflow Monitor.• Performed simple and complex transformations (Aggregator, Expression, Lookup, Joiner, Sequence Generator, Sorter, Stored Procedure, Update Strategy, etc.,) as part of Mapping between source and target.• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Union, Update Strategy and Sorter.• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.• Performance tuning of sources, targets, mappings and SQL queries in the transformations.• Performed Incremental loading by means of loading recently modified/added record into DW• Map existing sources/feeds to the Data Warehouse fields.• Build the ETL layer to load data from ODS to Data mart.• Data validation checking, and adding new columns.