Yugesh Ravi Godavarthi

• Around 9 years of experience in Information Technology with a strong background in Database development and Data warehousing (OLAP) and ETL process using Informatica Power Center 9.x/8.x/7.x/6.x, Power Exchange, Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor. • Experience in SQL tuning using Hints, Materialized Views. • Done integration of the AXON with Informatica EIC/EDC. Achieved Data Governance with Informatica AXON. Achieved Lineage for DQ and impact assessment via AXON. • Lead the Team in driving the development of IFRS Business Rule Development in EDQ • Worked on Power Exchange bulk data movement process by using Power Exchange Change Data Capture (CDC) method • Master Data Management concepts, Methodologies, and ability to apply this knowledge in building MDM solutions • Experience in UNIX shell programming. • Expertise in Teradata RDBMS using Fastload, Multiload, Tpump, Fast export, Multiload, Teradata SQL Assistant, and BTEQ utilities. • Worked with Informatica Cloud for creating source and the target object, developed source to target mappings. • Expertise in Dimensional Data Modeling using Star and Snow Flake Schema. Designed data models using Erwin. • Understanding of Relational (ROLAP), Multidimensional (MOLAP) modeling, data warehousing concepts, star and snowflake schema, database design methodologies, and Metadata management. • Experience with preparing functional Specifications, Low Level and High-Level Design specification, and Source to target mapping documents for the ETL programs/business processes • Experience in Creation and managing user accounts, security, rights, disk space, and process monitoring in Solaris and Red hat Linux. • Extensive knowledge in handling slowly changing dimensions (SCD) type 1/2/3. • Experience in using Informatica to populate the data into Teradata DWH. • Experience in understanding Fact Tables, Dimension Tables, Summary Tables • Migrated existing development from servers onto into Microsoft Azure, a cloud-based service. • Wrote Adhoc data normalization jobs for new data ingested into Redshift. • Moved the company from a SQL Server database structure to AWS Redshift data warehouse and responsible for ETL and data validation using SQL Server Integration Services. • Exposure to development, testing, debugging, implementation, user training & production support. • Excellent Analytical, Written, and Communication skills.