Pravallika Mayaluri

Associate data analyst primarily involved in the complete SDLC development comprising requirement analysis, mapping construction, system level testing and application maintenance. Proficient in development of ETL applications using Informatica Powercenter. Experienced in handling end to end development and migration of ETL applications comprising complex mappings, reusable transformations and mapplets. As Offshore coordinator supervised the development operations and reviewed deliveries.

Informatica Developer - Responsible for the extraction of business requirements from client and transforming them into executable mappings. Developed ETL mappings comprising complex transformations objects like update strategy, aggregator, stored procedure, transaction control etc. Developed ETL logics to load data from Salesforce to Teradata. Responsible for the creation of test cases in ALM to validate ETL developments. Performed Unit and Regression testing to validate the quality of the deliverables.

Analyzed the Functional Specifications provided by the data architects and prepared Low-Level Design documents. Developed Informatica Mappings to handle SCD (Slowly Changing Dimensions). Optimized database queries using EXPLAIN PLAN to increase runtime efficiency. Created UNIX scripts to perform post processing operations. Responsible for the documentation of ETL Migration and preparation of Technical Specification Document, that defined the source to target mapping structure.