SUMMARY

• 6 years of overall experience in the Information Technology Industry.
• 5 years of experience in working with data warehouses and using Informatica Powercenter 6.1, 7.1, 8.1, 8.6, 9.1 Designer, Repository Manager, Workflow Manager and Workflow Monitor .
• Data modeling experience using ERWIN.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Expertise in configuration, performance tuning, installation of Informatica, in integration of various data sources like Oracle, Teradata, MS SQL Server, XML and Flat files.
• Extensive experience with databases MS SQL Server 2000/2005/2008, Oracle 8i/9i/10g, Teradata .
• Extensive work with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Understanding working knowledge of Informatica CDC Change Data Capture .
• Experienced in tuning Informatica mappings to identify and remove processing bottlenecks.
• Experienced with Informatica Data Explorer IDE / Informatica Data Quality IDQ tools for Data Analysis / Data Profiling and Data Governance.
• Hands on experience on Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Good working knowledge and experience with Oracle Data Integrator ODI .
• Experience in working with COBOL files, XML, and Flat Files.
• Experience of Unix shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like AutoSys.
• Proficient knowledge in ETL using SQL Server Integration Services SSIS .
• Ability to prioritize and execute tasks in a high pressure environment.
• Reliable, proactive, responsible, hardworking and good team player.
• Reliable, proactive, responsible, hardworking and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SSIS

BI Tools: Cognos BI Suit, SSRS

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata, Sybase

Web Servers: IIS v5.0/6.0, Apache Tomcat

OS: Windows 2000/2003/XP/Vista/Windows 7, UNIX/Solaris, AIX

Version Control: Visual Source Safe 6.0, CVS

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT Dimension Tables, ETL, OLAP, Agile, Software Development Life Cycle SDLC

Tools: Toad, Rational Rose, MS Project, Test Director, MS Visio, Autosys

Professional Experience

Confidential

Sr. ETL/Informatica Developer

Environment: Informatica Power Center 9.0.1, Power Exchange, Oracle 10g, SQL server 2008, Toad,Teradata, UNIX.

Responsibilities:

• Gathering business and technical requirements for the project.
• Evaluating business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes. Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Extensively practiced Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Involved in Initial loads, Incremental loads Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner. Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance. Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache Static, Dynamic and Persistence and Join cache while developing the Mappings. Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Extensively used Power Exchange to integrate the sources like Mainframe MVS, and XML files.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without nay operator intervention.
• Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.

Confidential

ETL/Informatica Developer

Environment: Informatica Power Center 8.6.1, Informatica Power exchange , Oracle 10g, Toad, UNIX Shell Scripting, Flat Files,Teradata, Microsoft Office

Responsibilities:

• Participating in business/technical discussions to understand the report requirements which involve client's technical team to help us understand existing design.
• Generated shell script to automate the process for daily and nightly Loads, Developing PL/SQL procedures.
• Designing reporting environment database based on the reporting technical requirements.
• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Design and develop Extract Transform and Load ETL and Data Integration ETL solutions for complex functional and technical requirements using Informatica Power Center and Power Exchange.
• Design and develop CDC and Datamap using Power Exchange 8.6.1
• Creating Power Exchange Registration and Customizing power Exchange connection property and creating restart token.
• Transcribed the PL/SQL logic into Informatica mappings
• Involved in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Used Teradata as a Source and a Target for few mappings.
• Experience in writing PL/SQL, SQL codes, shared in the procedures and packages.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and many more..
• Involved in migration of objects in all phases of project.
• Maintain existing code and fix bugs

Confidential

ETL/Informatica Developer

Environment: Informatica PowerCenter 8.6/8.1, Oracle 10g, SQL developer, Erwin, Flatfiles, TOAD,PL/SQL, MS SQL Server, Autosys, UNIX.

Responsibilities:

• Worked closely with Manager and Database Administrator
• Analyzed functional specs and created technical documentation.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica powercenter.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Created ftp connections, database connections ODBC for the sources and targets.
• Backup/Restoration of repositories.
• Implemented various workflows using transformations such as JAVA transformation, XML transformation, Normalizer, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager.
• Experience with writing and executing test cases for data transformations in Informatica
• Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g.
• Analyzed performance tuning of Oracle 10g to improve its performance.
• Developed Shell Scripts to automate file manipulation and data loading procedures
• Proficient with Visual Source Safe for version control for Informatica objects, Oracle views and packages and test scripts.
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Prepared Test cases based on Functional Requirements Document.
• Developed Procedures and Functions in PL/SQL for Data ETL.
• Involved in Unit, System, Performance, Concurrent and QA testing.

Confidential

ETL/Informatica Developer

Environment: Informatica Power Center 7.1/8.1, Oracle 9i, Autosys, Erwin, MS PowerPoint, MS Visio, TOAD, PL/SQL, UNIX, SQL server

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Designed and developed processes to support data quality issues and detection and resolutions of error conditions.
• Working with the Business Analysts and the QA team for validation and verification of the development.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Implemented various scenarios related to slowly growing targets and slowly changing dimensions Type1, Type2, Type3 .
• Implemented various business rules of data transformations using various Informatica transformations.
• Worked with newer Informatica transformations like Java transformation, Transaction Control.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
• Worked on Oracle Warehouse Builder for already existing workflows to get the final source files for use.
• Wrote shell script utilities to detect error conditions in production loads and take corrective actions, wrote scripts to backup/restore repositories, backup/restore log files.
• Heavily involved with performance tuning of Oracle database using TKProf utility, working with partitioned tables, implementing layer of materialized views to speed up lookup queries, working with Bitmap indexes for dimension tables, DBMS Stats package to update statistics, using SQL hints.
• ETL processes migrated Informatica objects from development to QA and production using deployment groups.
• Provided production support and involved with root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.