Description
Professional Summary: * Around 11 years of strong Data Warehousing experience using Informatica Power Center 9.6.1/9.1/8.x//7.x/6.x and Informatica Data Quality. * Experience in all the phases of Data warehouse life cycle involving Business Requirements, Analysis, Design, Development, Implementation, and Testing of Data warehouse/Data Mart systems. * Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema). * Extensive experience in Banking, Financial and Pharmaceutical domains. * Extensive experience in implementing CDC using Informatica Power Exchange 8.x. * Developed Data Quality mappings using Parser, Labeler, Standardizer, Merge, Match, Case Converter, Consolidation, Key Generator, Association, Exception and Address Validation * Developed Data Quality Rules, Reference tables, Profiles and Scorecards based on the business requirements * Conducted extensive Data Profiling to cleansing, conforming and transforming massive data that is critical to the business. * Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 12c/11g/10g/9i/8x, SQL Server 2005, Teradata V2R5, Excel sheets, Flat Files, DB2. * 4 years of work experience in Teradata tools & utilities (Mload, Fload, Fast Export and Bteq). * Extensively worked with Oracle PL/SQL Stored Procedures, Functions, and Packages and also involved in Query Optimization and performance tuning. * Expertise on Informatica & IDQ installation and configuration. Upgraded the Informatica Version from 9.1.0 HF-6 to 9.6.1 HF-3. * Installing the Informatica Patches, EBS fix, applying Hotfix and performing backups of the repository. Performed Purging, truncating logs and collecting the stats on repository tables to improve the repository performance. * Expertise in Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments, managing Users, Groups, and associated privileges. * Experienced in UNIX work environment, file transfers, job scheduling and error handling. * Experienced in calling the REST-API through UNIX scripts. * Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks. * Good knowledge on Development, Testing, Debugging, Implementation, Documentation and Production support. * Having good exposure in OLAP tool Business Objects. * Strong Team building and mentoring skills and excellent Team leadership capability. * Experience in Defect management-JIRA, Version management - Subversion/Clear case/VSS/SharePoint, service desk & service now release management
Accomplishments
Highlights:
Keywords
