Uma I

• The goal of the project is to help the marketing team to better understand the current marketing strategy and the customer behavior by integrating the data from multiple sources including customer, sales, google analytics, marketing channels and products to enable business insights.
• Responsibilities:
• Perform requirement analysis through coordination with business analysts and define business and functional specifications.
• Perform Initial Data Profiling exercise
• Provide documentation of ETL design and technical specifications, high level and low level
• design specifications.
• Create test cases for Unit testing, Integration testing and User acceptance testing.
• Design develop and troubleshoot t-SQL stored procedures functions tables views triggers indexes and constraints.
• Handling semi-structured datasets and data load strategies error data
• Design and execute the data quality mappings that will cleanse project data
• Implement data quality processes including parsing, analysis, standardization and enrichment at point of entry and batch modes.
• Made use of Post-Session success and Post-Session failure batch scripts in the Session task to execute scripts needed for cleanup and update purposes.
• Assist with task identification and effort estimates for ETL development as per Agile Development methodology.
• Work with an offshore team to develop and deliver the ETL tasks.
• Using Debugger to test the data flow and fix the mappings.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.
• Involve in Production Support and troubleshooting data quality and integrity issues.
• Code migrations, resolving production issues, managing tickets in the support system.

The goal of the project is to assist the Revenue Management team by providing the historical and

statistical sales data to generate daily, weekly and monthly revenue reports. Identify the improvement

areas in the existing ETL, create and work on enhancement requests. Support the existing ETL

framework as part of production support.

Responsibilities:

● Worked on multiple projects as an ETL designer and developer.Extensively used Informatica

Power center to develop mappings.

● Interact with the Business users and the requirements team to identify process metrics, various

key dimensions and measures.

● Developed mapplets, reusable transformations and use them in different mappings.

● Worked on identifying and automating the process wherever possible resulting in extensive

project cost benefit to the client.

● Designed the ETL mappings between sources to operational staging targets, then to the data

warehouse using Powercenter Designer.

● Developed near real time batch jobs to replicate legacy data into salesforce every two minutes

using control M and Informatica power exchange.

● Extensive implementation of the Bulk API, Soap API and Metadata API concepts in Salesforce.

● Used Web Service transformation and Web Service targets to call and execute functionalities in

the Salesforce (WSDL).

● Extensively used the power exchange for Salesforce CRM to read, look up and load the data.

● Designed and Developed ETL audit and control model and components.

● Involved in Unit testing, System testing to check whether the data loads into target are

accurate, which was extracted from different source systems according to the user

requirements.

● Preparing and using test data/cases to verify accuracy and completeness of ETL process.

●Worked in different POC’s across the Organization.

● Involved in defining ETL framework, Data Integration points, ETL naming standards, ETL

Development-QA-Production migration process.

●Developed Shell scripts to automate file manipulation and data loading procedures

● Analyzing existing ETL Process, developing ETL strategies and processes, writing ETL

specifications.

● Extensively used Informatica- Power center for extracting data from various source systems like

database, flat file etc, transforming and loading into different databases.

● Designing, developing and testing Different Mappings according to Requirements.

● Wrote the shell scripts in UNIX for automating the job.

● Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer,

Workflow Monitor, Workflow Manager and Repository Manager.

● Used Source Analyzer and Warehouse designer to import the source and target database

schemas.

● Used the Mapping Designer to map the sources and target.

● Worked extensively on different types of transformations like Source qualifier, Expression,

Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.

● Unit Testing and Integration Testing for application

● Communicating and conducting UAT .