SUMMARY:

• Over 9+ years of SDLC Experience in Design, Development, Implementation, Maintenance and Testing of Data Warehouse and Data Integration Applications using ETL tool Informatica Power center 10/9.x/8.x/7.x and informatica data quality.
• Worked with Business Analysts to understand requirements and translated them into ETL code in Requirement Analysis phase.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources systems like Oracle, SQL server, Mainframe, DB2, Flat Files, XML etc using ETL and ELT approach to Data Warehouse
• Implemented Data Warehousing Methodologies for ETL using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console using the Velocity methodology and best practices.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Implemented Slowly Changing dimensions, Type 1, Type 2 for accessing the full history of accounts and transaction information.
• Extensive experience with working on the Inmon and Kimball Data Warehouse Design Approach and other DW concepts and methodologies including Logical data model, Conceptual data model, Physical data model (Star Schema, Snowflake schema and Fact constellations) and load and design of Facts (Additive, Semi - Additive, Non-Additive, Factless etc.) and Dimensions (Conformed, Junk, Role-playing, Slowly Changing Dimension)
• Experience in Debugging of prod support issues and Performance tuning of targets, sources, mappings and sessions.
• Strong experience in Data warehousing, Data Integration, Data Migration and Conversion projects.
• Good experience with Informatica Metadata in Data lineage and Repository Management
• Strong in analytical and conceptual skills for database design and development using Oracle 12 c/11g, MS SQL Server 2012/2008
• Proficient in developing SQL, T-SQL, PL/SQL packages, stored procedures and Triggers.
• Developed UNIX scripts to perform sanity checks like data file availability, checking header/trailer records, row counts, processing status and embedded PMCMD commands for calling Batches and Sessions from the command mode.
• Familiarity with Hadoop and informatica Big data platform.
• Experience in Informatica Administration activities like Creating and Managing Repositories, Users, User Groups, Folders,
• Hands on experience Business Intelligence (OLAP) Tools such as OBIEE11/10, SAP Business Objects, MS Power BI etc
• Team player and self-starter with good communication skills and ability to work independently and as part of a team

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.0/9.6/8.6.1/8.1 , Informatica Power Exchange 8.1, Informatica Data Quality(IDQ), Informatica DVO, Informatica Big Data.

BI/OLAP Tools: OBIEE, Cognos, SAP Business Objects, MS Power BI, Tableau.

Big Data: Hadoop, Yarn, HDFS, Hive, Pig, Map Reduce, Cloudera.

Databases: Sybase 11, Exadata, Oracle 12c/11g, MS SQL Server 2012/2008, DB2 V 8.x/7.x, Teradata, Netezza.

Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, ERWIN 4.1 .

Programming: SQL, PL/SQL, COBOL, Korn Shell Scripting, HTML, VBScript, JavaScript, XML, Java, JDK.

Tools: FTP Pro, Quest Central for DB2, TOAD, SQL Navigator, SQL*Loader, Visual Interdev 6.0, Autosys, MS Visio, Expresso, Microsoft SharePoint, BMC Remedy, Service Now

Operating systems: UNIX (Sun-Solaris, AIX 4.3/4.2 HP/UX), Windows Server 2012, Linux

Version Control: CVS, PVCS, MS Visual SourceSafe, IBM Rational Clear Case, Serena Dimensions.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Implemented Data Warehousing Methodologies for ETL using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console using the Velocity methodology and best practices.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Implemented Slowly Changing dimensions, Type 1, Type 2 for accessing the full history of accounts and transaction information.
• Extensive experience with working on the Inmon and Kimball Data Warehouse Design Approach and other DW concepts and methodologies including Logical data model, Conceptual data model, Physical data model (Star Schema, Snowflake schema and Fact constellations) and load and design of Facts (Additive, Semi - Additive, Non-Additive, Factless etc.) and Dimensions (Conformed, Junk, Role-playing, Slowly Changing Dimension)
• Experience in Debugging of prod support issues and Performance tuning of targets, sources, mappings and sessions.
• Strong experience in Data warehousing, Data Integration, Data Migration and Conversion projects.
• Good experience with Informatica Metadata in Data lineage and Repository Management
• Strong in analytical and conceptual skills for database design and development using Oracle 12 c/11g, MS SQL Server 2012/2008
• Proficient in developing SQL, T-SQL, PL/SQL packages, stored procedures and Triggers.
• Developed UNIX scripts to perform sanity checks like data file availability, checking header/trailer records, row counts, processing status and embedded PMCMD commands for calling Batches and Sessions from the command mode.
• Familiarity with Hadoop and informatica Big data platform.
• Experience in Informatica Administration activities like Creating and Managing Repositories, Users, User Groups, Folders,
• Hands on experience Business Intelligence (OLAP) Tools such as OBIEE11/10, SAP Business Objects, MS Power BI etc