SUMMARY

• Informatica Certified professional having around 8 years of experience in Data Warehouse/Data mart implementations teamed with Analysis, requirements gathering, Effort Estimation, ETL Design, development, System Integration testing, Implementation and production support
• In - depth hands on experience in ETL/ELT architecture and development .
• Worked on Administrative activities like creating deployment groups, assigning privileges and code migrations.
• Experienced in performance tuning by implementing pipeline partitioning, push down optimization, persistence cache etc.
• Experience in resolving on-going maintenance issues, bug fixes and bottlenecks at various levels like sources, targets, mappings and sessions.
• Implemented audit and alert strategies throughout ETL processes.
• Good Knowledge in implementing Slowly Changing Dimensions SCD (Type1 and Type 2).
• Strong in Data Warehousing concepts as well as methodologies, Star Schema and Snowflake Schema dimensional models .
• Experience in integration of various data sources like Oracle, xml, Excel, Teradata, DB2, Vsam, .csv, Text files and web services.
• Experience in creating reusable transformations and complex mappings, sessions, and workflows for high volume and high complexity processing.
• Capable of analyzing the business requirements and creating technical specification documents.
• Hands on experience in using IDQ; used various Informatica Data Quality transformations like Parser, address validator, standardizer, labeller, Match, case, Merger and Exception transformation.
• Experience in parsing Cobol copy books thru Informatica.
• Worked on Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load, TPT to export and load data to/from different source systems including flat files.
• Extensive experience of using Informatica PowerCenter 9.5.1/8.6.1/7. x and Tableau.
• Hands on experience in Data profiling and Unix shell scripting.
• Good knowledge on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer
• Experience in scheduling Informatica Jobs using DollarU and have good knowledge on Autosys.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes success / failure rates for analysis as maintenance part.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i, Teradata, DB2, SQL Server

Tools: TOAD, Putty, Power Term, Harvest and HP-QC Kintana, Toad, SQL-Assistant. DollarU, DACAutosys, Tidal, PVCS

Business Intelligence: OBIEE 11g/10g, Tableau, P6 Analytics

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6/7. x/6.XAbintio, IDQ 9.5.1

Operating Systems: Windows NT/XP, UNIX AIX, AS400

Languages: C, SQL and PL/SQL, COBOL, Java, JCL

PROFESSIONAL EXPERIENCE

Confidential

ETL- Developer

Environment: Informatica Power Center 9.5, Tableau, COBOL, Oracle11g, Teradata, SQL Server

Responsibilities:

• Translated the business processes/SAS code into Informatica mappings for building the data mart.
• Used Informatica powercenter to load data from different sources like flat files, COBOL files and Oracle, teradata into the Oracle Data Warehouse.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Developed reusable transformations and mapplets to use in multiple mappings.
• Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Involved in data quality checks by interacting with the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Created Tableau extracts and developed reports by using Tableau.
• Created sites and assign privileges to them on tableau.

Confidential

IT-Engineer

Environment: Informatica Power Center 9.5.1, OBIEE, Oracle10g/11g, TERADATA, TOADSQL-Assistant, Unix, PVCS, Kintana, Dollar Universe.

Responsibilities:

• Designed the ETL architecture.
• Implemented pushdown optimization (PDO), pipeline partition, cache techniques for efficient loading.
• Used Informatica Data Quality (IDQ) transformations like Parser, address validator, standardizer, labeler, Match, case, Merger and Exception transformation for data quality.
• Implemented automation, audit and alert strategies throughout ETL processes.
• Implemented Java Transformation logic to transform the data.
• Designed restart-ability through ETL processes.
• Identify the data cleansing elements and prepare the specifications for data cleansing.
• Extensively used Informatica to extract wide range of data from different sources like flat files, XML, Excel spread sheets, Teradata and Oracle into the Data Warehouse.
• Performed Unit Testing and tuned the mappings for the better performance.
• Coordinated with business analysts to gather the new requirements and to work with the existing issues.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Involved in data quality checks by interacting with the business analysts.
• Developed complex mappings to load Dimension & Fact tables.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created documents for complex transformations in ETL process to support knowledge transfer to other team members.
• Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Scheduled the ETL Jobs using Dollar Universe.
• Created pre-session and post-session shell scripts and email notifications.

Confidential

Project Lead

Environment: Informatica Power Center 8.6.1, OBIEE, Oracle9i/10g,DB2, TOAD 9.1 Windows XP, UNIX AIX, IBM Mainframe, Harvest, HP-QC, Autosys

Responsibilities:

• Involved in Extraction, Transformation and Loading of data using Informatica.
• Translated the business processes/requirements into Informatica mappings for building the data mart.
• Involved in Unit, System integration and User Acceptance Testing for the project.
• Extensively used Informatica to extract wide range of data from different sources like flat files, Excel spread sheets, and Oracle into the Oracle Data Warehouse.
• Performed Unit Testing and tuned the mappings for the better performance.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Used the Debugger to debug the mappings by setting Breakpoints across instances to identify the root cause of errors.
• Developed simple & complex mappings to load Dimension & Fact tables.
• Worked on different tasks in Workflow Manager like Sessions, Event raise, Event wait, Decision, Email, Command, and Worklets.
• Communicate with the client for updating weekly status reports.