PROFESSIONAL SUMMARY:

• 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center.
• 6 years of experience in using Informatica PowerCenter 9.x/8.x
• 1 year of experience in SSIS Package development SQL 2008
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power center.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS:

• ETL Tools : Informatica PowerCenter 9.x/8.x/7.x, SSIS
• Database : SQL Server 2008/2012, Oracle 11g/10g/9i
• DB Tools : SQL Plus, TOAD, SQL Loader
• Environment : Windows 2000/2008
• Languages : SQL, PL/SQL
• Reporting Tools : Microsoft SSRS
• Other Tools/Utilities : HP Quality center, Autosys

WORK EXPERIENCE:

Confidential

ETL Informatica developer

Responsibilities:

• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment Dev, QA
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica Power Center 9.1.0/8.6.1, Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Oracle 11, SQL Server 2008, Web services, Autosys

Confidential

ETL Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica Repository Manager, Designer, Workflow Manager Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Used Informatica Power Center 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy Sequence Generator.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Scheduled batch jobs using Autosys to run the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, Autosys, SQL, Teradata, SQL LOADER, TOAD, Shell Scripting

Confidential

ETL Informatica developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup Connected and Un-Connected , Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 8.6 .1, Oracle 11g, SQL Server 2005, HP-UX.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Involved in Business Requirements analysis and design, prepared and technical design documents.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable components such as Mapplets, Reusable transformations and sessions etc.
• Involved in loading the data from Source Tables to ODS Operational Data Source Tables using Transformation and Cleansing Logic using Informatica.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router
• Developed mapplets and worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Implemented partitioning and bulk loads for loading large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Involved in performance tuning of mappings, transformations and workflow sessions to optimize session performance.
• Created Materialized views for summary tables for better query performance.
• Implemented weekly error tracking and correction process using Informatica.
• Developed Documentation for all the routines Mappings, Sessions and Workflows .
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 8.6/9.0.1, Oracle 10g, DB2 9.0, UNIX AIX , WINSQL, Windows 7, Business Objects XI 3.1, PL/SQL, Flat files, MS SQL Server 2008, MS-Access, Autosys, Subversion, C .net, Ultra Edit.

Confidential

ETL Developer

Responsibilities:

• Performed specification documentation for each SSIS process based on client's requirements.
• Developed various transformations, mappings and sessions in Informatica to load data from source to target database.
• Extensively used Transformations like Aggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformations
• Tested all the mappings developed and checked the data transformations.
• Used Quality Center to track the defects.
• Performed error checking and testing of SSIS procedures and programs in dataflow task.
• Constantly worked on performance tuning of mappings and sessions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Updated the SDS documents with the respective changes.

Environment: SSIS, SQL Server 2008 Oracle 10g, SQL, PL/SQL, Quality Center, IDQ, Windows 2003.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL processes to load data from Flat files, SQL Server and Access into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Involved in standardizing the data being stored from various Business Units into the warehouse tables.
• Created complex and robust mappings and Mapplets using Mapping designer and Mapplets to generate different mappings for different loads.
• Fine-tuned existing Informatica mappings for performance optimization.
• Used Power Center Server Manager and workflow monitor to schedule and monitor different sessions of loading.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Involved in writing the PL/SQL procedures and PL/SQL program units for data extraction, transformation and loading.

Environment: Informatica PowerCenter 7.1.3 Repository Manger, Designer, Workflow Monitor, Workflow Manager , Flat files, Oracle, MS SQL Server 2005, Windows NT, PL/SQL, Erwin 4.0,Toad, UNIX, SQL Plus, PL/SQL, Flat files, MS-Access, Control-M.