Radaamani M S Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

• Leading a team of 6 members and involved in hiring, mentoring & guiding the new joiners• Discussions with clients/prospects to demonstrate features of our product & onboard them seamlessly• Played a key role in the Roadmap discussions, Design discussions, Customer Support.• Active involvement in Estimates & Billing, Sprint Planning, Retrospection & Auditing.• Work with business analysts to gather business requirements from end users and translate them into technical… Show more • Leading a team of 6 members and involved in hiring, mentoring & guiding the new joiners• Discussions with clients/prospects to demonstrate features of our product & onboard them seamlessly• Played a key role in the Roadmap discussions, Design discussions, Customer Support.• Active involvement in Estimates & Billing, Sprint Planning, Retrospection & Auditing.• Work with business analysts to gather business requirements from end users and translate them into technical specifications & define data definitions, transformation logic, and data flow, and process.• Responsible for providing technical guidance/solutions & assist team members with critical Oracle PL/SQL code needed for queries, triggers, and stored procedures.• Perform code reviews, data analysis and data profiling against source systems and data warehouse.• Design data marts to support Business Intelligence reporting.• Test solutions to validate the requirements, develop test plans, test scripts, and test conditions based on the business and system requirements. Show less

Bengaluru, Karnataka, India

• Design data marts to support Business Intelligence reporting & design ETL processes using Informatica Power Center.• Test solutions to validate whether requirements have been met, develop test plans, test scripts, and test conditions based on the business and system requirements.• Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.• Perform root cause analysis on all… Show more • Design data marts to support Business Intelligence reporting & design ETL processes using Informatica Power Center.• Test solutions to validate whether requirements have been met, develop test plans, test scripts, and test conditions based on the business and system requirements.• Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams. Show less

Bengaluru, Karnataka, India

• Analyzing and Understanding business and customer requirements. • Converting the Functional specifications into ETL specification documents.• Involved in Requirement gathering and interacted with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Oracle, Flat files into a common target area such as staging and final… Show more • Analyzing and Understanding business and customer requirements. • Converting the Functional specifications into ETL specification documents.• Involved in Requirement gathering and interacted with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Oracle, Flat files into a common target area such as staging and final tables/flat files.• Used most of the transformations such as the Source Qualifier, Expression, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, Java and Update Strategy.• Imported data from various Sources transformed and loaded into Staging Area and final tables/ flat files.• Developed slowly changing dimensions mappings as per requirement.• Involved in Creating Sessions, Workflows, Worklets Using Workflow Manager.• Involved in Performance tuning of mappings.• Involved in Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.• Excellent knowledge on all advanced concepts like workflow concurrent execution, Indirect Loading for Flat Files, Target load plan, Constraint based loading.• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.• Used CONTROL-M to run and schedule the jobs.• Have experience in support and knowledge transfer from different company. • Responsible for monitoring the sessions that are running, scheduled, completed and failed.• Handling change requests and implementation of the same in the mapping or session as requested by the user.• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.• Created procedures to truncate data in the target before the session run.• Sound working knowledge in Oracle and Unix Show less

Bengaluru, Karnataka, India

• Developed mappings to populate data in the database.• Developed mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.• Handling change requests and implementation of the same in the mapping or session as requested by the user.• Creating mappings to load data from SAP source… Show more • Developed mappings to populate data in the database.• Developed mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.• Handling change requests and implementation of the same in the mapping or session as requested by the user.• Creating mappings to load data from SAP source system to Oracle to transform the data and upload into SAP.• Responsible to migrate the Informatica code from one environment to another environment.• Responsible for implementing SAP conversion functions and generating ABAP programs.• Created Sessions, reusable Worklets in Workflow Manager and scheduled the sessions to run at a specified frequency.• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.• Parameterized the mappings and increased the re-usability.• Created procedures to truncate data in the target before the session run.• Created Test cases for the mappings developed and then created Unit Testing Document.• Created post-session and pre-session shell scripts and mail-notifications• Written Unix Shell Scripts for getting data from various source systems.• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.• Created UNIX shell scripts to run the Informatica workflows.• Production Support has been done to resolve the ongoing issues and troubleshoot the problems. Show less

Bachelor Of Engineering (B.E.), Computer Science

D.Com.E, Computer Engineering

Education record