Setty

About Setty

18 years of IT experience in Conceptualization,Source Data Analysis, Data Model Design, Development, Testing, Data Standardization, Integrationand ProductionSupport for Data warehouse and Business Intelligence systems using ETL, BI toolsand Web applications on Unix and BigData platforms in various verticals. Experience working in Financial, Healthcare, Human Resource, Claims, Education and Security/IdentityDomains. • Led Various Data Mart implementations including Data Model design and integrated it with the existing Data marts in the Warehouse. • Extensive experience in conducting meeting with Business Users/BSAstocapturebusiness requirement, translating them into Technical Specification for the Data warehouse implementation. • Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Model design techniques (data Granularity, Facts and dimensions, Star, Snow-Flakeschemas, Data Vault model and confirmed dimensions). • Complete knowledge of data warehouse methodologies (Ralph Kimball, Bill Inmon and DanLinstedt), ODS, EDW and Metadata Management. • Extensive knowledge in designing and working with Data Vault Data Models with Hubs, Links and Satellites. • Expert-level mastery in designing and developing complexETL Informatica mappings using various transformations, to implement logic such as slowly changing dimensions, CDC, Point-in-Time data snapshot and incremental/Delta data load. • Extensive experience in using ETL/ELT toolslike Informatica PowerCenter, Power Exchange, Informatica Cloud, Data Stage andextracting data extraction from heterogeneous sources like Oracle, SQL Server, SAP, Flat File (CSV, XML, JSON), salesforce, Big Data Databaseslike Hive, and Mainframe Database like DB2, ADABAS/VSAM Files. • Expert-level mastery in designing and developing complex Informatica mappings using various transformations, to implement logic such as slowly changing dimensions, Point-in-Time data snapshot and incremental loading. • Experience in source systems analysis, identifying data sources, data profiling and data cleanings using Informatica IDQ/IDE. • Experience in developing security structures for data warehouse to give data access to business users based on their granted roles/responsibilities. • Expert in Performance tuning the existing ETL Loads by analyzing mappings to identify bottle necks and tuning SQL Queries, mappings, sessions to optimize performance. Provided training to the developers to develop better performing mappings. • Extensive experience in using ETL toolslike Informatica PowerCenter, Power Exchange, IDQ/IDE, MDM and SSIS. • Extensive knowledge of implementing BIG DATA Solutions like YARN, HIVE,SQOOP, FLUME, SPARK, PAYTHON, PIG and KAFKA.