Devi Anuradha M. Email & Phone Number

• ETL Informatica expert with 8+ years of IT experience. Experience in analysis, design, development, implementation, and troubleshooting of Data warehouse applications.• Experienced in Informatica PowerCenter 10.2, 9.6.1, 9.1 along with a strong background ETL skill for Data warehousing using Informatica.• Experienced in developing ETL applications and statistical analysis of data on databases ORACLE 11g/12c, Teradata 16, PostgreSQL, and SQL Server.• Experience integrating data to/from On-Premises database and cloud-based database solutions using Informatica Intelligent Cloud Services (IICS)• Developing the codes for different frameworks like NAS to GCS, GCS to GCS, GCS to ACQ, and ACQ to Integration Layer; used Python Script for job execution.• Experience in Informatica IICS Monitor the task flows and Workflows.• Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio• Have ability to write and interpret complex SQL statements and good in SQL optimization and performance tuning.• Moderate experience in implementing CDC using Informatica Power Center• Extensively worked on Informatica Power center transformations as well like Expression, Joiner, Sorter, Filter, Router, and other transformations as required.• Good in Data Warehouse Concepts like Dimension Tables, Fact tables, Slowly Changing Dimensions, DataMart’s, and Dimensional modeling schemas.• Experience in Data modeling; Dimensional modeling and E-R Modeling and OLTP AND OLAP in Data Analysis. Very familiar with SCD1 and SCD2 in snowflake schema and star schema.• Strong experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components.• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger project.• Experience in writing UNIX shell scripts, automation of ETL process, error handling and auditing purposes.• Experienced in the Control-M tool for developing jobs, scheduling the jobs and triggering jobs.• Expertise on Agile Software Development process.

• 

  Osmania University

  Computer Science