Venkata Ramana Sathivada

Project: 2 Description: (ETL Developer and Production Analyst) At STAR2 Data Warehousing we develop and support the ETL load of STAR2 data of TCS. Data from various applications including transactions is extracted and loaded to Oracle tables based on business logic. These jobs are scheduled using Autosys and Control-M.

• Create high level and detail design documentation of mapping, code move, test cases and Data flow documents.
• Tracking source target data flow and documenting it into an inventory for support level usage..
• Trained on Data quality requests to resolve the data issues and update the existing mappings as per the change in requirement.
• Extensively worked on Informatica PowerCenter Tool to formulate mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregator, source Qualifier.
• Involved in designing the Mappings and Reusable Transformations according to the ad-hoc business needs.
• Defect tracking and verification. Performance tuning & redesigning existing Informatica workflows.
• Detect unusually long running jobs and initiating investigations into root cause.
• Code migration to QA environment using STAR Team Application.
• Responsible for Successful Execution of workflows and Validation of Data according to the functional specifications of the business.
• Good technical background with Production Support on Oracle SQL, and UNIX scripting analysis.
• Process Improvement and automation of manual work through ETL, Enhancement of existing ETL code.
• Root causes analysis of PROD issues and providing solution for it.

Project:1 Description (Production Analyst and Executive) Tata Teleservices Limited (TTSL) is an Indian broadband and telecommunication services provider in India offering Fixed-line and mobile telephony, broadband and fixed-line internet services, digital television and network services.

• Deployment and maintenance of high priority applications that process data into client and business team.
• Trouble shooting & resolving functional, data level and technical issues in the day- to-day process.
• Performance tuning & debugging Informatica mapping issues.
• Performed Unit testing, Integration testing of Informatica mappings.
• Create various mappings to load data from sources like Oracle and Flat file into different stages like Landing, Staging and Target tables.
• Leveraged on Informatica PowerCenter Tool to formulate mappings to implement the business logic.
• Used transformations like lookup, update strategy, expression, filter, router, aggregator, source Qualifier.
• Performed Unit Testing, Integration Testing by creating test cases for the mappings developed.
• Involved in designing the Mappings and Reusable Transformations according to ad-hoc business needs.
• Defect tracking and verification and Performance tuning & redesigning existing Informatica workflows
• Code migration to QA environment using ITSME TOOL and Jenkins.
• Responsible for Successful Execution of workflows and Validation of Data according to functional specifications of the business.
• Maintenance of the Informatica ETL platform infrastructure upgrades, patches on application servers and health monitoring.
• Root causes analysis of PROD issues and providing solution for it.