Surendra Battula Email & Phone Number

Having 5.2 years of extensive IT experience in ETL methodologies Analysis, Design, Development, Implementation, Testing and Support of Data.Proficient in Informatica 9.x & 10.x, Oracle SQL, UNIX and Autosys.Experience in implementing business rules by designing and creating mappings, Sessions and Workflows using Informatica PowerCenter and IICS.Having experience working with informatica IICS tool effectively using it for data integration and data migration from multiple source system in SQL data warehouse. Proficiency in developing complex SQL queries with various relational databases like Oracle, SQL server.Possess complete domain and development Life Cycle knowledge of Data Warehousing.Extensively Designed SCD1, SCD2 mappings to load Dimension tables. Extensively on Incremental Loading and Fact Loading. Worked on Input and in-Out Parameters in IDMC.Worked on Target load Order and Constraint Based loading. Worked on creating mappings, mapping Tasks and Task Flows.Knowledge on Run Time Environment and Secure Agent. Information Technology with Technical and Functional Experience in maintaining data warehouses/marts. Proficiency in Data warehousing, ETL process, OLAP systems, Business Intelligence.Experience in developing Informatica Mappings/Mapplets to extract data from multiple sources, transform data, and then loaded into Operational Data Store (staging area) and then load into Data Warehouse.Experience in Creating complex mappings using Aggregator, Expression, Joiner, Filter, Sequence Generator Connected & Unconnected Lookup, Router, Union and Update Strategy transformations using Informatica PowerCenter designer.Experience in Creating SCD Type-1 and Type-2 mapping technique to load the data into various dimension tables.Experience in Fact Loading.Experience in Creating, Scheduling and configuring workflows, worklets and sessions using Informatica workflow manager.Experience in creating mapping parameters and variables to load the stage.

• 

  Etl Developer

  Synechron Technologies Pvt. Ltd.

• 

  Jawaharlal Nehru Technological University

  Electrical, Electronics And Communications Engineering