PROFESSIONAL SUMMARY:

• Having Total 7+years of experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center.
• Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing usingInformatica Power Center 8.6, Power Center 9.1, Power Center 9.6 and Power Exchange 9.6 Experience in Extraction Transformation and Loading of flat files as well as relational databases using Informatica mappings, sessions and workflows.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery. Experience in Working with Very Large Data Warehouses of about 20+ Terabytes.
• Designing, Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems with latest versions 9.1 and 9.5.1.
• Experience in creating UNIX shell scripts.
• Experience in Conceptual, Logical and Physical data model design techniques.
• Knowledge on Normalization techniques for database designing.
• Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes, SAP into the staging area, and Knowledge of Power Exchange.
• Experience in working with Business Analysts, Data Modelers to understand requirements and to create sustainable ETL applications, technical design documents that capture source to target mapping, define transformation algorithms and document data quality rules.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in writing database objects stored procedures, Functions and Packages.
• Experience in understanding underlying data models and design/develop scripts using SQL.
• Experience in performance testing of various ETL processes/stored procedures and provide solution to the performance improvement.
• Experience in gathering information from the system, analyzing program and time requirements, and preparing documentation to change existing programs.
• Experience in finding Root cause analysis (RCA) and resolving static and post production issues.
• Good Operating Systems knowledge and associated commands (UNIX, MS Windows).
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ETL: Informatica Power Centre

Database: Sybase IQ, Sybase ASE, Oracle, DB2, SQL Server

Operating Systems: Windows, UNIX

Programming Languages: SQL and PL/SQL, TSQL

Tools: TOAD, SQL developer, SQL*PLUS

Data Modeling Tools: ERWIN, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential, Carrollton, TX

Responsibilities:

• Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.
• Prepared the Release Notes, Deployment plan, Unit Test document, Validation document, Migration document.
• Involved in Data Analysis and Data Validation.
• Created Staging Database from source as Flat Files, Access, Oracle, My SQL, Data from Operational Source System is extracted and loaded into data warehouse Using Teradata.
• Created scripts using Fast Load, Multi - Load to load data into the Teradata data warehouse.
• Created different Mapping for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expressions, Aggregator, and Sequence Generator.
• Designed and Developed the Informatica workflows/sessions to load the data into target DWH.
• Scheduled Workflows on the Informatica Server using Informatica workflow Manager.
• Involved in Code migration to different Repositories (Dev/Test/Prod).
• Interacted with DBA's, Informatica Admin team to resolve the issues.
• Implemented Performance Tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Design logical and physical data model using Erwin data modelling tool and visio.
• Worked with Netezza, DB2 Software's, reporting team to create email alerts per site, by daily.
• Wrote Unix Shell scripts to execute Stored Procedures.
• Production Support & Maintenance.

Environment: Informatica Power Center 9.5.1, Oracle 10g, Teradata 14.0 and 13.0, SQL Server 2008, Netezza, DB2, TOAD, Erwin, SQL*Plus, PL/SQL, MY SQL, Windows, Unix, EBS.

Confidential, CA

ETL Informatica Developer

Responsibilities:

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Created reusable mapplets and transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Involved in writing UNIX Shell scripts to run informatica workflows.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. .
• Involved in performance tuning by optimizing the mappings and sessions.
• Prepared test scripts and Unit test the mappings and checked for data validation and data integration.

Environment: Informatica Power Center 8.6, Oracle 10g, Unix, Windows XP.

Confidential, San Diego, CA

Responsibilities:

• Developed ETL mappings, transformations using Informatica Power Center.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Worked on the server manager to run sessions and batches concurrently and sequentially.

Environment: Informatica Power Center 8.x, Oracle10g, SQL*plus, Windows XP.

Confidential, Thousand Oaks, CA

Responsibilities:

• Created mappings to load source data into target tables
• Developed mappings, mapplets and reusable transformation to facilitate one time, daily, monthly and yearly loading of data.
• Used various transformations in informatica.
• Created tasks and workflows in the workflow manager and monitors the sessions in the workflow monitor.
• Responsible for preparing mapping documentation.
• Responsible for identifying test case scenarios for unit testing.

Environment: Informatica Power Center 9, Oracle 11g, SQL*plus, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Developed multiple Datastage mappings and jobs involving complex transformations to various clients within enterprise.
• Designed and developed Datastage jobs which integrate data from various sources and loads into DB2.
• Documented Datastage Jobs, Sequences and Automation process of Data conversion to facilitate the business to understand the process.
• Used various stages of Parallel Jobs such as Aggregator, Sort, Transformer, Sequential file, Join, Merge and lookup.
• Developed Datastage jobs to read multiple transaction files from different countries and load it into target tables like product, relationship.
• Generated Job design reports for management to keep track of design changes and its impact.
• Shell Scripts were written to schedule the job.
• Used Clear case for Versioning of ETL jobs and scripts.
• Used HP-QC for tracking issues, and share point to upload and access the project documents, mapping and functional specs.
• Involved in Performance tuning of the Datastage jobs.
• Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.

Environment: IBM Datastage 8.1, DB2, Oracle, Clear Case, HP QC, Shell Scripting