? 8+ years of extensive experience in design, development, Implementation & maintenance of Informatica ETL processes, OLTP & Data Warehouse systems, Business Intelligence and Enterprise Application Integration. ? Extensive expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica PowerCenter10.x/9.x, Informatica B2B and Microsoft SSRS. ? Experience in all the phases of software life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment and Agile Methodology. ? Experience in data modelling for OLTP relational databases and Data warehouse applications using Ralph Kimball and Bill Inman design principles including Facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modelling - Star and Snow Flake Schema. ? Proficient in designing and developing Data Marts in a data warehouse for business subject areas. ? Experience in integration of various data sources like Oracle, SQL server and non-relational sources like Flat files and XML files. ? Expertise in implementing Change Data Capture (CDC), Operational Data Store for real-time data (ODS), Incremental extracts and slowly growing target for data warehouses. ? Extensively involved in Quality Assurance, bug fixing and testing. Prepared user manuals, presentations and trained users and operators. ? Strong SQL, PL/SQL programming skills in Oracle, SQL Server databases. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization. ? Proficient in running Explain Plans for SQL queries to identify performance issues. ? Expertise in deploying and maintaining Informatica ETL code in Production environment. ? Experience with issue and project management tool Rally to track defects. Solid experience in project documentation including Technical specifications and Technical Design Documents (TDD). ? Performance tuned Informatica mappings by adopting explain plans, cutting down query costs using Oracle hints, changing the mapping designs.