Kumar

About Kumar

• Overall 8+ Years of strong IT experience in analysis, design, development and testing client server environment with focus on Data Warehousing application using tools like Informatica Power Center 10.x/9.x/8.x, Business Objects with Oracle, SQL Server databases and IDQ. • Involved in Software Development Life Cycle (SDLC) involving Application Development, Data Modeling, Business Data Analysis and ETL/OLAP Processes. • Strong Data Warehousing ETL experience of using Informatica 10.1/9.6.1/9.1/8.6.1/8.5/ Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager. • Experience in Microsoft Business Intelligence technologies like SQL Server Integration Services, SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). • Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter9.x/8.x, IDQ and Trillium. • Performed the data profiling and analysis making use of Informatica Data Quality (IDQ). • Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner. • Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio Data modeling tools. • Experienced in developing meta-data repositories. • Worked on PROVIDER, CLAIMS, MEMBER subject areas. • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases • Strong experience in Informatica Data Quality (IDQ), creating data profiles, custom filters, data cleansing and developing score cards. • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server, DB2 8.0/7.0, UDB, No SQL Databases, Mongo DB, MS Access and Teradata. • Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart, Star/Snowflake schema implementations. • Implemented Data Vault Modeling Concept solved the problem of dealing with change in the environment by separating the business keys and the associations between those business keys, from the descriptive attributes of those keys using HUB, LINKS tables and Satellites. • Utilized knowledge on PL/SQL and Data Vault for transforming operational data into data warehouse cloud in Snowflake. • Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality. • Strong experience in writing complex SQL Queries, Stored Procedures and Triggers. • Experience in Agile/Scrum, TDD and BDD methodologies • Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions. • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. • Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.