PROFESSIONAL SUMMARY:

• More than 8 years of IT experience in Data Warehousing technology in Informatica PowerCenter, Informatica MDM, Oracle, Teradata, SQL Server.
• Extensive working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation & Data Loading (ETL) methodologies.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• High exposure on MDM Hub configurations - Data modeling for Sources and Systems, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, Hierarchy Manager.
• Exceptional acquaintance in configuring the Match and Merge Rules in the MDM Hub by defining properties for Fuzzy and Exact match, creating path components, columns and Match Rule Set
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, and OLAP, ROLAP, MOLAP, Fact and Dimension tables.
• Extensively used Slowly Changing Dimension (SCD) technique in banking application.
• Extensive understanding of Production issues and Data issues and provided Production support.
• Expertise in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, DB2 and SQL Server and Teradata databases.
• Strong understanding of RDBMS and proficient in writing PL/SQL Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Very strong skills on project management, requirement analysis, business analysis, database modeling, design and analysis, issue co-ordination and development with Teradata/Oracle/SQL Server based Relational Databases.
• Proficient in Teradata database design (conceptual and physical), Query optimization, Performance Tuning.
• Strong hands on experience using Teradata utilities (FastExport, MultiLoad, FastLoad, Tpump, BTEQ and QueryMan).
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Extensively worked on Performance Tuning techniques at various levels to increase the performance and minimize the time for work.
• Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Experience in UNIX Shell Scripting.
• Ability to self-manage time & task priorities to meet project timelines & identify potential project risks.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x, 9.x,10.x, Informatia Data Quality 9.x, Informatica MDM 9.x, SQL server2005/ 2008,Abinitio 3.1.6, Data Stage.

Reporting Tools: Cognos, OBIEE, Micro strategy 8.1, Tableau (Exposure)

RDBMS: SQL Server 2008/2005, Oracle 11g/10g/9i, DB2, Teradata 14, MS-Access 2003/2007/2010

Operating Systems: WINDOWS 7/Vista/XP/2003/2000/NT/98/95, UNIX 9.0, LINUX 8.x

Office Applications: Microsoft Word, Excel, Outlook, Access, Visio, Project, Power Point (2003/2007/ 2010 )

Dimensional Data modeling: Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Big Data Technologies: Hive QL(Basics), Pig Latin(Basics), Hadoop Basics.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• High exposure on MDM Hub configurations - Data modeling for Sources and Systems, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, Hierarchy Manager.
• Exceptional acquaintance in configuring the Match and Merge Rules in the MDM Hub by defining properties for Fuzzy and Exact match, creating path components, columns and Match Rule Set
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, and OLAP, ROLAP, MOLAP, Fact and Dimension tables.
• Extensively used Slowly Changing Dimension (SCD) technique in banking application.
• Extensive understanding of Production issues and Data issues and provided Production support.
• Expertise in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, DB2 and SQL Server and Teradata databases.
• Strong understanding of RDBMS and proficient in writing PL/SQL Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Very strong skills on project management, requirement analysis, business analysis, database modeling, design and analysis, issue co-ordination and development with Teradata/Oracle/SQL Server based Relational Databases.
• Proficient in Teradata database design (conceptual and physical), Query optimization, Performance Tuning.
• Strong hands on experience using Teradata utilities (FastExport, MultiLoad, FastLoad, Tpump, BTEQ and QueryMan).
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Extensively worked on Performance Tuning techniques at various levels to increase the performance and minimize the time for work.
• Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.