Shraddha Wakalkar

PROJECT DESCRIPTION

• Migrate CyC Organisation data to the Shared Component environment
• Migrate Atradius and CyC risk/underwriting data to new Arcade data base
• Migrate CyC Documents to Document Management System.

ROLES AND RESPONSIBLITIES

• Developed mappings, workflows and tasks
• Identified, troubleshot and corrected bugs
• Improved data accuracy by conducting thorough testing and debugging of Informatica mappings and workflows.
• Participated in code reviews, ensuring adherence to established coding standards and promoting continuous improvement within the team.
• Proactively identified potential bottlenecks in processes and implemented appropriate optimizations to mitigate performance impacts efficiently.
• Ensured data integrity through rigorous testing and validation of ETL code.

PROJECT DESCRIPTION

• HDFC Bank has an Operational Data Store (ODS), Data warehouse on SQL Server database and Business Intelligence reporting & analytical layer built on top of it
• In order to support HDFC Banks business strategy and information needs, need for an Enterprise wide Data Warehouse (EDW) is envisaged
• This EDW, along with a flexible reporting layer, is expected to provide reliable business information at the desired level of granularity in a secure manner.

ROLES AND RESPONSIBLITIES:-

• Developed mappings, workflows and tasks using

existing code as per requirements

• Supported production issues resolution by troubleshooting errors and providing timely remediation efforts.
• Enhanced data integration by designing and developing efficient mapping solutions and workflows.
• Improved data accuracy by conducting thorough testing and debugging of Informatica mappings and workflows.
• Analyzed columns by column for implementation of new system zeta

PROJECT DESCRIPTION

• Organization has an Operational Data Store (ODS), Data warehouse on SQL Server database and Business Intelligence reporting & analytical layer built on top of it
• In order to support business strategy and information needs, need for an Enterprise wide Data Warehouse (EDW) is envisaged
• This EDW, along with a flexible reporting layer, is expected to provide reliable business information at the desired level of granularity in a secure manner.

ROLES AND RESPONSIBLITIES

• Source :-Oracle,Salesforce Target:-Snowflake
• Experience in loading Various Dimension tables using SCD Type-1 & Type-2 .
• Experience in Extracting the data using Incremental loading.
• Created generic macro to make data consistent.
• Created taskflow
• Created Mapping parameters and variables using Parameterization.
• Tested the mapping to view data got populated according to specified logics in the technical specification document.
• To keep track of historical data slowly changing dimensions are implemented.
• Worked with Mapping Variables and Mapping Parameters.
• Checked the output according to the specifications

PROJECT DESCRIPTION

Company is seeking to partner implement a Datawarehouse in that will process incoming data and populate the new Tec Brands Enterprise Data Warehouse (EDW) to provide reliable and consistent reporting across all business units

These reports will enable meaningful analysis of data across a variety of sources and in addition, and empower strategic decision making.

ROLES AND RESPONSIBLITIES

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Used Informatica Power Center 10.2.0 for extraction, transformation and load (ETL) of data in the data warehouse.
• Worked on Informatica Power Centre client tools like Source Analyzer, Target designer, Mapping designer, mapplet designer and Transformation Developer.
• Used Informatica Power Center Workflow manager to create sessions and workflows.
• Developed complex mappings in Informatica to load the data from various sources.
• Created various transformations such as Aggregator, Sorter ,Lookup, Union, Expression, Joiner, Filter, Router, Normalizer, Sequence Generator transformations.
• Created mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica Reusable concepts like Reusable Transformations, Mapplets and Worklets at various levels of development
• Experience in loading Various Dimension tables using SCD Type-1 & Type-2 .
• Experience in Extracting the data using Incremental loading.
• Experience in working with Un-Connected lookups and Dynamic Lookups in informatica
• Created Mapping parameters and variables using Informatica Parameterization.
• Tested the mapping to view data got populated according to specified logics in the technical specification document.
• To keep track of historical data slowly changing dimensions are implemented.
• Worked with Mapping Variables and Mapping Parameters.
• Checked the output according to the specifications
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Experience in Dynamic File generation In Informatica.
• Tuned several mappings for the better performance and involved in Performance Testing.
• Involved in Unit Testing.
• Worked on UNIX commands.
• Provide weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Co-ordinated the offshore team for effective & quality deliverables.
• Reviewed the ETL code per the standards. Worked on Requirement of loading .CSV files to tables on Oracle using various Informatica transformations.
• Created Informatica Mappings to build business rules to load data using transformations like
• Have created ETL mapping, sessions, Workflows and Unix Ob-jects as per the business requirements.
• Worked with tools like Oracle SQL Developer to write queries and generate the result
• Worked with Session Logs, Informatica Debugger for the work-flows and session failures.
• Configuring the Databases connections in Informatica
• Verify the connection to the Databases.
• Determine source, target or mappings bottle necks for slow mappings.
• · Running the scripts manually for transferring the data file from Linux location to windows shared location.

PROJECT DESCRIPTION

Company is seeking to partner implement a Datawarehouse in that will process incoming data and populate the new Tec Brands Enterprise Data Warehouse (EDW) to provide reliable and consistent reporting across all business units. These reports will enable meaningful analysis of data across a variety of sources and in addition, and empower strategic decision making.

Roles and Responsiblities:-

• Efficient in using service now for tickets resolving
• Worked on P1 and P2
• Mointoring jobs on daily basis and made sure for smooth run
• On failure detailed investigation was done and tried to resolve it