Riti Mahajan

• Design, build, and maintain scalable data pipelines using Azure Data Factory (ADF) and Azure Databricks.
• Ingest data from various sources like SQL Server, Blob Storage, APIs, On-premise, etc.
• Use ADF for orchestration, data movement, and scheduling.
• Use Databricks for data transformation (ETL/ELT) using PySpark or Scala
• Automate workflows and job triggers in ADF.
• Monitor pipeline performance, debug failures, and handle error logging.
• Optimize ADF data flows and activities to reduce latency and cost.

• Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
• Experience in designing and developing high-quality ETL solutions to meet complex functional requirements.
• Took ownership of medium to large-scale projects, working independently and collaboratively to meet deadlines and exceed expectations.
• Developing IICS mappings, mapping configuration tasks, replication and synchronization tasks.
• Implemented data ingestion from on-premises to cloud using Self-hosted Integration Runtime and staging layers in Azure Data Lake.
• Worked on Multidomain MDM, Customer 360, Product 360, Reference 360, and Business 360.

Ø Prepare Release Notes and Implementation Plans for deploying the code to higher environment and support System testing and Quality Assurance testing.

Ø Worked with the business stakeholders to understand requirements, designed and developed workflows, mappings, and transformations, and implemented them in the production environment.

• Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.

• Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
• Configured and maintained cloud-based data infrastructure on platforms like Azure, enhance data storage and computation capabilities.

Conducted rigorous testing and validation of data pipelines to ensure accuracy and completeness of data.

• Streamlined data flow from diverse sources using ETL tools such as Talend, Informatica, and Airflow.
• Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
• Ø Trained on MDM SaaS by Informatica, and it includes all 360 applications (Customer 360, Supplier 360, Product 360, Reference 360, Finance 360 and Business 360 applications)

• Worked in Power Center to IICS migration project in Humana. IICS is getting used for data transformation and calculation. Once data is being pulled into staging area, further after applying various transformation through Informatica Cloud (ETL), it is loaded into Final layer. After this Humana has its On-Premises reporting tool which will generate reports based on this final dataset.
• Worked extensively on various SCD types
• Worked on all major transformations in IICS and integration between different components and replicating data using Replication tasks.
• Practical knowledge of loading data from source files in JSON and XML. Possess experience creating application integrations with REST and SOAP APIs, which are used to connect various systems.
• Should be well versed with different file formats for parsing files like Flat File, XML also should work with service connectors.
• Doing Analysis and finding the inconsistence in Informatica jobs, to resolve the discrepancies in output and sending the right data to the end user.
• Data from source systems is ingested into Azure data factory and data lake storage.
• Develop ETL pipelines using Azure Data Factory, leading to a 30% increase in workflow efficiency.
• Used Pyspark for processing and analyzing large data sets.
• Established and enforced naming standards for cloud-based data warehousing solutions, ensuring consistency and clarity across projects.

Ø Developed multiple Mappings from scratch, collaborated with the functional team to understand the requirements and actively performed Production support activities.

Ø Interaction with clients for the requirement gathering, Co-ordinate with onshore supervisor to discuss the design and development.

Ø Extensively worked on re-usable components(mapplets/worklets).

• MMC Health – Project includes extracting the data for Life insurance for Existing and New business through different vendor channels and source system, then loading into the Enterprise data warehouse to cater the need for decision making and different business processes.
• Responsible for mapping performance tweaking and locating bottlenecks in the current code.
• Analyze and understand the mapping specification for all mappings and clarify any doubts with product owners and architects.
• Document the requirements of the system and manage development and enhancement.
• Testing of the mappings in different environments after the development is complete.
• Experience in leading and guiding teams on various issues and prioritizing the task according to client requests.
• Developed mappings using all sorts of transformations and developed reusable components.
• Proactively involved and participated in establishing and creating the EDW data model and project architecture.

• Worked in projects starting from scratch and enhancement projects in UBS, JPMC and Ikano. WMP is a unified Wealth Management Program for UBS. UBS is spread across multiple geographies, and each has its individual application landscape which includes enterprise and in-house applications. As part of establishing a single centralized wealth management program, UBS has undertaken this program to consolidate identified subject area data from APAC region into a single enterprise platform.
• Created ETL mappings using Informatica Power Center and IICS to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc. to load the data into staging tables and then to target.
• Running the test flows, gathering the statistics, and identifying the bottlenecks in the mappings.
• Debugging the complex mapping logics, checking the performance of the mappings and sessions.
• Excellent communication, presentation, project management skills, a very good self-starter with ability to work independently and as a part of team.

• Worked on Mainframes in HSBC project. Hands on experience in COBOL, JCL, DB2, CICS and VSAM files.