Mahesh G.
Senior Etl Informatica Developer @CVS Health
Signup · Get unlimited contacts
WORK HISTORY
Senior Etl Informatica Developer @CVS Health
RI, US
Collaborated with Project Manager, Business analysts for requirements gathering, business analysis and designing of End to End solution for Accordant Project.• Involved in requirement analysis, ETL design and development for extracting data from different interfaces like MS SQL Server, Flat Files and loading into CVS Application Systems DB.• Extensively involved in creating ETL Data Mapping Design Document for Accordant Data Clients as per business requirements.• Involved in defining/creating MS SQL Server Objects like Tables Structures, Stored Procedures, functions, cursor as requirements.• Invoked and Executed Stored Procedures as a part of development process through Informatica to populate Supporting Base Tables.• Developed ETL Informatica mappings to load Tables using various transformations, which involves Source Qualifier, Expression, Lookup, Joiner, Router, Update Strategy etc. of Informatica.• Extensively used Informatica client tools Source Analyzer, Target/Warehouse designer, Mapping Designer, Transformation Developer, Informatica Workflow Manager and Informatica Workflow Monitor.• Involved in performance tuning and optimization of mapping to manage very large volume of data.
ABOUT MAHESH G.
Over 10 years of IT experience in analysis, design, development and implementation of Data warehouses, data marts using Informatica Power Center, DataStage with Oracle, MS SQL server, DB2.• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x, ETL tool.• Experience in performing ETL procedures to load data from heterogeneous sources like Oracle9i/10g/11g, DB2, SQL Server, Flat Files, • COBOL files and Teradata into Data warehouse using Informatica Power Center.• Extensively worked on overall SDLC implementation that includes requirement gathering, development, testing, debugging and deployment as well as Documentation, Production Support.• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modelling.• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.