Professional Summary :

• Over 8 years of IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solution. Good knowledge on Data Warehousing concepts like star and Snowflake Schema Methodologies along with the Strong financial domain skills and experienced SDLC- IT project lifecycle in a financial environment as the Senior ETL Informatica Developer.
• Expertise in Informatica 9.0.1/8.6.1, Autosys and DAC 10.1.3.3.1. Interacted with Business Analyst to understand the business requirements and also designed the ETL Mapping specifications for ETL Mappings of Data warehouse.
• Experience with Workflow Manager, Workflow Monitor, Mapping Designer, Source Analyzer, Transformation developer, Mapplet Designer, Repository manager.
• Created and Configured Workflows, Worklets and Sessions to load the data to target warehouse Oracle tables using Informatica Workflow Manager. Experienced various source databases like Oracle, IBM Netezza, DB2, Teradata, fixed width and delimited files. Designed many Multi Source Single Target mappings and vice versa.
• Experienced with reusability of ETL code by using mapplets and worklets. Experienced in UNIX work environment, file transfers, job scheduling and error handling. Developed transformation logic and designed various Complex Mappings and Mapplets using the Informatica Designer tool.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, java and Expression Transformations. Effectively developed and tested the type1, type2 Slowly Changing Dimensions mappings. Experienced with automation of ETL workflows with Autosys command line tools and GUI iXP tools and experienced FTP protocols in UNIX environment. Used Parameter files to define values for parameters and variables used in a mappings.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels. Designed ETL strategy for various applications in the financial line of business. Performed coordination with the offshore team for ETL Informatica deliverables with daily status calls and follows up on gap items on daily basis. Migrated the ETL code from one environment to another with various techniques like Folder Migration, Deployment Groups, Export Import objects successfully.

Technical Skills:

• ETL Tool: Informatica Power Center 9.5/9.1.0/8.x/7.1 Designer, Workflow Manager, Workflow Monitor, Repository Manager, Integration Services, Repository Services, Administration
• Console Power exchange for Netezza.
• ETL Scheduling tool :Autosys, DAC 10.1.3.3.1,iXP tool
• Databases: Oracle 11g/10g/9i/8i/8.0/7.x, Teradata14/13/12, SQL Server 2005, Sybase, MS Access, DB2, flat files
• Scripting languages:Unix Shell Scripting Korn ,Power shell
• Operating Systems: Windows 2003/XP,UNIX ,Linux
• Middleware Tools : Sql Plus, Toad for Data Analyst 2.5,Toad for Oracle, F-Secure Client,IBM Data Studio, MS Visio,SQL assistant for Teradata.

PROJECTS DETAILS:

Confidential

Lead Informatica Developer

Project Synopsis: Confidential is a One of the Commercial Application in Shire. This project will maintain all kind of business data between Doctors, Representatives and business team's Sales Operations in different Nations, Regions, Zones and Territories.

Responsibilities:

• Worked on Scheduling workflows and sessions using Informatica scheduler and have implemented decision task and email task for tracking the successful completion
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Creating Business Reports.
• Reviewed the business specifications and requirements and translated them to technical design ETL mappings.
• Worked with business users to resolve their issues.
• Preparing backend and business test scripts.
• Working on production issues.
• ETL Testing
• Worked on Flat files and DB files.

Environment: Business Objects BI 4.0 ,Netezza 6.0,Informatica 9.01,UC4,Linux, SFTP , BUGZilla File Server.

Confidential

ETL Informatica Developer

Project Synopsis: Confidential data repository system . different zone data marts will load the data daily based on scheduled zone times.

Responsibilities:

• Reviewed the business specifications and requirements and translated them to technical design ETL Mapping specifications along with HLD and LLD for the project.
• Worked with the QA Onsite team on SIT and UAT issues. Supported the PROD environment. Daily coordination with offshore ETL development team.
• Involved in analysing the source data coming from different data sources such as Oracle, DB2 and Flat files. Presented the overall project specifications to the all ETL Developers, QA team members and reporting team members too.
• Worked on FTP protocols in UNIX environment. Implemented few scripts which perform few data operations with files that we load into oracle platform.
• Used Parameter files to define values for parameters and variables used in a mappings.
• Apply service packs and patches and Upgrade the Informatica environment
• Developed ETL procedures to ensure conformity, compliance with CareFirst standards
• Created Migration Documentation and Process Flow for mappings and sessions.
• Developed the transformation logic identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Created Informatica server administration automation scripts, shell scripts for data manipulation and process automation using shell scripting.
• Developed Shell Scripts which take care of truncate table, Archival the source and the target files and Clean up the log files
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document.
• Mentored the team of 4 technical persons for any technical issues, enhancement to the existing system, fixing the issues in the existing system or new changes.
• Designed multi dimensional Star schema,Generated the database scripts, E-R diagrams.

Environment: Informatica 9.1.0, OBIEE 11.1.1.5.1, DAC, Autosys, Oracle, DB2, Toad for Data Analyst 2.5, Toad for Oracle, PL/SQL,Unix.

Confidential

Sr. Informatica Developer

Project Synopsis: Advanced Monitoring Infrastructure: the client had the requirement of creating AMI data mart that requires data related to Truck activities, pipeline measurements and receipe combination of customers products information .

Responsibilities:

• Working as an ETL / Data warehouse engineer in the Receipe Data Warehouse RDW team focusing on Receipe, Truck activity Dimensional structures and extracting data from various legacy source systems.
• Collection and translation of business requirements into technical pipeline ETL Design, Mapping document, Unit test cases suitable for RDW implementation.
• Extensive worked on Informatica 8.6.1 mappings, session, workflow in creating various mappings focusing on changing dimensions.
• Developed transformation logic and designed various Complex Mappings and Mapplets. Used Autosys as a scheduling tool for triggering workflows to load dimensional data.
• Using Perforce as a versioning tool for maintaining revision history for code.
• Developed numerous Complex Informatica Mapplets and reusable Transformations.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter and Router Transformations.
• Optimized Query Performance, Session Performance and Reliability.
• Implemented stored procedures, functions, views, triggers, packages in PL/SQL.
• Used Source Pre-Load and Post-Load, Target Pre-Load, Target Post-Load functionality of Stored Procedure Transformation. Worked on ETL strategy to store data validation rules, error handling methods to handle both expected and non expected errors.
• Used Update Strategies for cleansing, updating to the data in the warehouse.
• Designed and developed UNIX shell scripts as part of the ETL process.
• automate the process of loading, pulling and pushing data from to different servers.

Environment: Informatica 8.6.1, OBIEE 11.1.1.5.1,Unix,shell scripting, Sql , Teradata, DAC, Autosys, Data Analyst 2.5, Toad for Oracle, Teradata sql assistant

Confidential

Sr. Informatica Developer

Project Synopsis: Confidential is the leader in clothing factory.URR Ultimate Redemption Rate is the project to maintain different types of datamarts.

Responsibilities:

• Tier 3 Production support specialist, Provided Analysis, fixing, documenting the issues.
• Provides Informatica ETL development and support for the Enterprise data warehouse.
• Involved in Disaster recovery exercise program as for Data Warehouse.
• Involved and worked as main resource for upgrading from Informatica 8.6 to 9.1.0.
• Involved and worked as main resource in migration from our input vendors WKH to IMS.
• Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries.
• Develops and maintains mappings within the Informatica ETL tool.
• Designing documenting the functional specs and preparing the technical design.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets Parameter files in Mapping Designer using both the Informatica Power Center.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Power Center transformations and sessions using techniques like Explain plans, Oracle hints , re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameter.
• Creating Checklists for Coding, Testing and Release for a error free project flow
• Development of new code that adheres to current system design and/or make recommendations on improvements to the design.complies with coding standards.
• Modified the existing ETL Informatica jobs in order to get the report of each load taking place with the time and number of records that have loaded and extracted as well
• Documented all the development work in the format as per the requirement.

Environment: Informatica 9.1.0, Oracle, Teradata, DAC, Autosys,Data Analyst 2.5, Toad for Oracle, Teradata sql assistant