k

About k

• 8+ years of IT Experience in Data Warehousing, Database Design and ETL Processes in various business domains like finance, telecom, manufacturing and health care industries. • Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using Informatica Power Center. • Worked extensively on ETL process using Informatica PowerCenter 9.x/8.x/7.x. Informatica Data Quality(IDQ) 9.6.1, Informatica MDM and Informatica B2B • Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate-wide-ETL solution using Informatica Power Center. • Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads. • Experience working with CloudComputing on Platform Salesforce.com • Extensive experience in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer. • Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in E-commerce software, Utility,Pharmaceutical,Health Care, Insurance, Financial and Manufacturing industries. • Experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes and triggers. • Experienced in IDQ (9X, 9.5.1) handing LDO’s PDO’s & some of the transformation to cleanse and profile the incoming data by using Standardizer, Labeler, Parser, Address Validator Transformations8 years of experience in using different versions of Oracle database like 11g/10g/9i/8i. • Excellent working knowledge of c shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX. • Proficient with Informatica Data Quality(IDQ) for cleanup and massaging at staging area. • Experience in creating batch scripts in DOS and Perl Scripting. • Experience in ETL development process using Informatica for Data Warehousing, Data migration and Production support. • Experience in both Waterfall and AgileSDLC methodologies. • Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) – Star/Snowflake schema, SCD, Surrogate keys and Normalization/De-normalization. • Data modeling experience in creating Conceptual, Logical and Physical Data Models using ERwin Data Modeler. • Experience with TOAD, SQL Developer database tools to query, test, modify, analyze data, create indexes, and compare data from different schemas. • Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ). • Worked on Slowly Changing Dimensions (SCD's) Types -1, 2 and 3 to keep track of historical data. • Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data. • Proficiency in data warehousing techniques for data cleansing, surrogate key assignmentand Change data capture (CDC). • Experience in integration of various data sources like Oracle, DB2, Flat Files and XML Files into ODS and good knowledge onTeradata 12.0/13.0, SQL Server 2000/2005/2008 and MS Access 2003/2007. • Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings. • Hands on experience in MDM development. • Involved in the designing of Landing, Staging and Base tables in Informatica MDM. • Created MDM mapping and configured match and merge rules to integrate the data received from different sources. • Optimized the Solution using various performance-tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Indexes, partitioning, Materialized Views, Procedures and functions). • Extensively used Autosys and Tidal for scheduling the UNIX shell scripts and Informatica workflows. • Extensive knowledge in all areas of Project Life Cycle Development. • Stronganalytical, verbal, written and interpersonal skills.