SUMMARY:

• Over 6 years of experience in Development and Implementation of Data Warehousing with Informatica Power Centre 9.X/ 8.x. Unix, Linux, Tidal, Autosys.
• Expertise in RDBMS like Oracle 11g/10g, Teradata 14.1, MS Access, SQL Server, SQL, PL/SQL, SQL PLUS, TOAD, SQL Assistant etc.
• Worked on developing and implementing complex business rules by creating Mapping s, Mapplets, Sessions, Workflows, and worklets, Reusable or non - reusable objects for data loads.
• Knowledge of complete SDLC including Requirement analysis and gathering, development and Testing, End to End implementation.
• Strong Experience in Execution, schedule workflows using Informatica default Scheduler, Tidal, Autosys, Control M to load data from Source to Target.
• Using agile methodology for SDLC and utilize scrum meetings for creative and productive work.
• Extensively used various transformations such as Source Qualifier , Filter , Expression , Update Strategy , Look-up , Sequence Generator , Joiner , Router, Aggregator, and Stored procedure transformation etc.
• Knowledge on Dimensional data modeling, Star schema , Snowflake schema , Data Normalization.
• Expertise in using properties and configuration of I nformatica clients and Utilities-- Source Analyzer, Target Designer, Mapping Designer, Workflow Manger, Workflow Monitor, Mapplet, Worklet, and Transformation Developer.
• Design and developed complex mappings such as Slowly Changing Dimensions Type 2 (SCD Type 2).
• Strong experience in Performance tuning using Partition, Pushdown Optimization, Fast Load, Multi-Load along with SQL and Informatica component tuning.
• Experience in writing/debugging/enhancing UNIX Shell Scripts and Worked on UNIX shell scripts to handle Job Control Process.
• Experience in writing Stored Procedures, Functions, Packages, Cursors and Triggers.
• Experienced in requirements gathering, Document Analysis, planning,, build, and maintenance
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.5.1/8.6, IDQ, Informatica Power Analyzer/ Power mart 9x

Operating System: Windows 08/07/XP/2003, UNIX, Linux, Putty, WinScp

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

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, XML/XSD, Quality Center 9.0/8.2

Web Technologies: HTML, XML, Front page, Dreamweaver,Eclipse, JAVA

Reporting Tool: Cognos, Microstrategy.

Other Tools: SQL *Plus, Toad, Teradata SQL Assistant, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, MADISON, WI

ETL/I nformatica Developer

Responsibilities:

• Involved and understanding the Business requirements/ discuss with Business Analyst, analyzing the requirements and helped architect preparing business rules.
• Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update Strategy, Aggregator, Router, Stored Procedure to implement complex logics while create mappings .
• Developed mappings workflow using Informatica to load data from homogeneous and heterogeneous sources and Targets such as Relational tables, Flat files, Excel Files.
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.
• Contributed and actively providing comments for user stories review meeting within AGILE SCRUM environment.
• Extensively worked on SQL override in Source Qualifier, Look Up, Aggregator Transformation for better performance.
• Hands on experience using query tools like TOAD, Teradata SQL.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Implemented slowly changing dimension (SCD Type 1 & 2) in various mappings.
• Used Incremental Aggregation technique to load data into aggregation tables for improved performance.
• Created Directory, Parameter file, and Shell Scripts to interact Internal and external environments.
• Created and maintained Job Groups, Jobs, Job activity on Autosys to schedule workflow and provided informatica job Support.
• Worked on different Tasks in Workflow Manager like session, event raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
• Experience in writing UNIX and automation of the ETL processes using UNIX shell scripting.
• Prepared ETL standards, Naming Conventions and wrote ETL flow documentation.

Environment: Informatica PowerCenter 9.6.1 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Power Mart, Cognos, Oracle 11g/10g, SQL, PL/SQL, Unix, Erwin, Putty, Winscp, QC(Quality Center),Windows XP, Autosys.

Confidential, Los Angeles, CA

ETL/Informatica Developer

Responsibilities:

• Understand and offered Informatica expertise to design mapping documents with data architect, Project Lead, and Manager.
• Integrated data across different Homogeneous and Heterogeneous sources and Targets systems like Relational Database, Flat Files, Teradata, and Mainframe.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica Power Center and Power Exchange.
• Extensively worked on Informatica clients such as Source Analyzer, Target Designer, Designer, Transformation, Mapplet and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Used output xml files, removed empty delta files and FTP to output xml and Flat Files to different server.
• Extensively worked on Informatica Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Imported and Exported tables and Informatica objects from Database to Informatica to Desktop and vice versa.
• Performed Code Migration from DEV to TEST both in Informatica, Unix environments, and created migration documents
• Created ODBC and Relational Connections and File Path.
• Integrated Data from source system to Stage database, Load Layer, and Data Warehouse using Informatica Clients and process.
• Created shortcut s for reusable source/target definitions, Reusable Transformations, Mapplets in Shared folder.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, connected & unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, XML Transformations and Update Strategy & Sequence Generator.
• Extensively worked on performance tuning using Informatica best Practices, Partition, Pushdown Optimization, Fast-Load, Multi-Load etc.
• Implemented restart strategy , debugging, root cause analysis , and error handling techniques to recover failed sessions.
• Wrote SQL Override, Teradata Store Procedure, function and performed data validation in the Data Warehouse and Data-Mart.
• Worked on Tidal Schedulers to create Job Group, Jobs, scheduled workflows and Provided Job support proactively when required.
• Created Unix, Shell Script, and Parameter Files to create user friendly, maintainable and reusable objects.

Environment: Informatica Power Center 9.6.1, Teradata, Mainframe, Teradata SQL Assistant, TOAD, XML,SQL,PLSQL, Erwin4.0, Unix, Putty, Windows, Tidal.

Confidential, Lansing MI

Informatica Developer

Responsibilities:

• Designed and deployed overall ETL strategy including SCD’s, Partition Management, Materialized Views and other complex mapping logics.
• Transform and Load data into Enterprise Data Warehouse tables using Informatica from the legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Implemented appropriate Error handling logic, data load methods and capturing invalid data from the source system for further data cleanup.
• Developing shared objects in Informatica for source/target/lookup transformations, developed complex mappings, sessions/workflows/worklets, database connections.
• Entered metadata descriptions at both the transformation and port level in complex mappings
• Design the ETL process and schedule the stage and mart loads for the data mart.
• Debugging and Troubleshooting Informatica Mappings.
• Developed wrapper shell scripts for calling Informatica workflows using PM/CMD command and Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• SQL Query tuning including Explain Plan, using Optimizer Hints, Indexes and Histograms.
• Involved in Postproduction support and enhancements.
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse
• Worked closely with the Requirements Manager and business Analysts on the requirements collection process.
• Assisted the tester in developing the test cases and reviewed them.
• Have thorough experience on Defect Management.

Environment: Informatica Power Center 8.1, ORACLE 9i, UNIX Shell Scripts, WinSCP.