Description
PROFESSIONAL SUMMARY * 4 years of IT professional experience in designing, analysis, programming and testing using Informatica PowerCenter 9.x/8.x/7.x/6.x. * Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions. * Extensive experience in Developing Informatica complex mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with worklets & tasks and scheduling using workflow manager. * Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects. * Experience in providing end-to-end business intelligence solution by dimensional modeling design, development, and loading, building business models, configuring metadata and validation dashboard reports. * Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling. * strong Data Modeling experience with conceptual and data modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries. * Involved in complete SSIS life cycle in creating SSIS packages building, deploying and executing the packages in various packages * Experience in installation and configuration of MS SQL server 2008/2012/2014 * Created databases, tables, views, joints, stored procedures to retrieve data from table using MS SQL and oracle * In my Master's I gained exposure to various programming language like C, C++, JAVA, .NET while I was working in various projects. * Got a chance to take Database and JAVA as my core subjects * Proficient in writing complex Oracle SQL, Views, for database applications. * Very good exposure to Oracle 11g, 10g, 9i, 8.x, MS SQL Server 2000/2005, IBM DB2, Teradata databases * Hands on experience working in UNIX and Windows environments. * Worked in Agile process involved sprint planning, scrum meeting, ticket grooming and retrospective meetings
Accomplishments
Highlights:
Keywords
