SUMMARY

• Around 8+ years of experience in data warehousingand data migration projects using tools like Informatica power center 9.6.1/9.1/8.6/8.1.1/7. x and Power Exchange.
• Good noledge of data warehouse architecture and designing star schema, snow flake schema, fact and dimensional tables, physical and logical data modeling using Erwin.
• Hands on experience in designing data load strategy for slowly changing dimensions and various granular levels of fact tables.
• Installing teh Informatica application server and configuring teh Repository and Integration services in Informatica Admin Console.
• Having noledge of implementing data validation rules and exception handling mechanism while loading dimension and facts.
• Proficiency in data warehousing techniques for data cleansing using IDQ (Informatica Data Quality).
• Experience wif Informartica PowerExchange, PowerCenter Enterprise HA/Grid, Informatica Data Quality.
• Good noledge on data modeling concepts.
• Hands on experience through complete Software Development Life Cycle (SDLC).
• Experience in developing PL/SQL procedures.
• Experience in working wif Oracle, Teradata and MySQL databases.
• Experience in working wif Java, XML and HTTP transformations using Informatica.
• Expertise in UNIX shell scripts and used in Informatica pre/post session operations.
• Expertise in designing teh job dependency schedules using UNIXCronttab and scheduler tools like CTRL - M and Autosys.
• Worked wif PMCMD to interact wif Informatica Server from command line.
• Good working noledge in Unit testing, Functional, System, Performance, User Acceptance Testing.
• Excellent communication, presentation skills, a very good team player and self-starter wif ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center- 9.6.1/9.1/9.0/8.6.1 , Informatica IDQ

OLAP Tools: BusinessObjects,Cognos

Databases: Oracle, DB2, MySQL

Languages: Java, SQL, PL/SQL, Shell Scripting.

Tools: /Utilities: TOAD, SQL Navigator.

Operating Systems: Windows, Unix, Linux

Version Control Systems: SCM,PVCS

PROFESSIONAL EXPERIENCE

Confidential, MI

Informatica Administrator

Responsibilities:

• Analyzing teh business requirements based on dat building teh technical Design documents.
• Performing software installations and configurations and perform teh Airlock Testing.
• Creating ETL jobs to integrate teh data from different source systems.
• Designing teh custom reports as per teh business requirement.
• Supported theMDM Architect to assist in teh definition and execution for teh overallMDM strategy, wif clear mastery Data Quality andMDMtechniques.
• Analyzing different platforms to implement teh applications.
• Supporting teh production real-time ETL’s and Reports.
• Implementing Best practices for better performance and maintenance.
• Analyzing ongoing implementation requirements and designing teh technical documents.
• Creating users and Groups and assign teh privileges.
• Install teh Informatica application in Linux/Unix System.
• Configuring Domains and nodes in Informatica server.
• Configuring teh Repository and Integration services.
• Configuring teh .profile/.bash profile files
• Monitoring teh logs and update teh configurations to improve teh performance.
• Install and configure teh additional licenses.
• Creating teh connections in Workflow Manager.
• Coordinating wif UNIX team and applythe patches in Informatica Server
• Upgrading Informatica application from 9.0.1 version to 9.6.2 version.
• Configuring Web service in Informatica server.

Environment: Informatica Power Center 9.0.1/9.6.1 , Oracle-11g, Business Objects-XI4, TOAD, UNIX

Confidential

Informatica Administrator

Responsibilities:

• Preparing teh operating system wif pre requisites for Informatica PowerCenter 9.0 environment
• Installing, configuring Informatica Power Center 9.0 environment
• Installing and integrating IDQ 9.0 wif Informatica Power Center 9.0
• Define Informatica best practices and naming standards
• Performance tuning of Informatica code by identifying bottlenecks
• Installing and configuring Informatica Data Quality 9.0
• Applying hotfixes to teh Informatica Power Center environment
• Troubleshooting Power Center related issues for project application teams
• Designing automated script based code migration using Informatica utilities like pmrep
• Developing scripts for command line workflow execution using Informatica utility pmcmd
• Designing metadata repository backup and restore strategy
• Automating Informatica general user and folder setup
• Implementing Operating System profiles
• Designing scripts to monitor Informatica services
• Configuring Native security model and assigning roles and privileges to groups and users
• Work wif Informatica Vendor to debug product related issues
• Code review before migration of Informatica code to testing environment
• Document teh project artifacts and processes
• Updating Data quality address validation dictionaries as per teh subscription frequency
• Designing rollback strategy for production migrations
• Designing and testing disaster recovery strategy
• Benchmark system performance for maximum load capacity and planning for future growth.
• Generating Informatica Power Center statistics using metadata queries
• Configuring native connectivity to database servers like Oracle, Sybase, DB2
• Configuring ODBC connectivity to Sql Server database using. Odbc.ini file
• Designing file directory structure for run time files for Informatica Power Center for optimum performance
• Setup training lab for GM Financial which included setting up Informatica Power Center training environment

Environment: Informatica Power Center 9.0, Oracle-10g, Cognos, RedHat Linux

Confidential

ETL Developer

Responsibilities:

• Developed high level technical design specification and low-level specifications based on business requirements.
• Developed Informatica ETL code using various mappings and transformations for transport of data from different sources to files.
• Involved in teh full development lifecycle from requirement gathering through design, build, QA, deployment and support using power center.
• Used Informatica Data Quality tool to clean teh address data for vendors.
• Developed Data mart for procurement business unit.
• Create a mapping wif Java transformation to retrieve teh procurement documents like PDF, JPEG from BLOB data type columns from oracle database.
• Developed robust Informatica mappings and fine-tuned them to process millions of input records wif estimated throughput.
• Designed teh workflows wif trigger files to create dependencies between workflows to load data in one table after another.
• Used mapping variables and parameters in Informatica mappings to minimize teh code changes and to reuse teh code.
• Created UNIX scripts to run teh Informatica commands thru command line.
• Designed Control table logic to implement incremental loads from source system.
• Created Slowly Changing Dimension to keep history data in target tables.
• Debugging invalid mappings using break points, testing of Informatica sessions, batches and teh target Data.
• Involved in performance and tuning teh ETL processes.
• Worked on estimating Informatica work, planned teh development activities and delivered them on time.
• Worked wif other teams like DBA, Informatica Admin to get teh requirement tasks completed on time.

Environment: Informatica Power Center 9.1, Oracle, OBIEE, TOAD, UNIX

Confidential, TX

ETL Developer

Responsibilities:

• Interacted wif business users for requirement analysisand to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule using RUP(Rational Unified process)
• DevelopedComplex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW).
• Prepared software requirement specifications, business rules interacting wif business units and designed Star schema, logical and physical database design for Domains.
• Designed ER diagrams, logical model (relationship, cardinality, attributes and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Used FLOAD, MLOAD utilities to load data into Teradata tables to achieve better performance.
• Transformed teh data via standardization, cleaning, data repair and deduping.
• Removed duplicate rows from tables through teh process of deduping.
• Developed data Mappings, Transformations between source systems and warehouse.
• Performed code reviews for teh mappings developed by other team members.
• Managed teh metadata associated wif teh ETL processes used to populate teh data warehouse.
• Implemented mappings using Aggregator, Filter, Join, Expression, Lookup and update strategytransformations.
• Used Bteq’s and Teradata Utilities like multiload, fastload, tpump to achieve teh good performance when working on huge volumes of data.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Generated variousError handling and failure recovery strategies.

Environment: Informatica Power Center 8.6, Teradata, MySQL, Cognos, UNIX