PROFESSIONAL SUMMARY:

• 8 Years of IT Experience in Software Design, Development, Testing and Deployment using SDLC and Agile methodologies.
• Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System Support.
• Data processing knowledge in designing and implementing Data Warehouse applications, mainly Transformation processes using ETL tool Informatica Power Centre 9.6/9.1/8.6.1/8.1.1/7.1.2 .
• Working experience in Development, Enhancement and migration projects.
• Have involved in end to end project activities i.e. from gathering Business needs, converting them into requirements, analysis, design activities, build to testing phases, reviews and in release management.
• Extensively used Informatica for ETL purposes on various sources and targets like Flat files, Oracle, SQL Server, XML, Mainframes DB2, Netezza, and IBM DB2.
• Extensively worked on Designer, Repository Manager, Workflow Manager and Workflow Monitor using Informatica ETL Tool.
• Sound knowledge in administration tasks including importing/exporting mappings, copying Workflow objects.
• Strong experience using Oracle, DB2, MS SQL Server, Netezza, XML.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Experience in Unix Shell scripting and Perl Scripting.
• Worked with Data Architect and DBA in preparing Logical and Physical data models.
• Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies, slowly changing Dimensions.
• Working experience in Informatica Uplift from 9.1 to 9.6.1.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6/9.1/8.6/ 8.1/7.1 , SSIS

BI/OLAP Tools: SSRS, Crystal Reports, Cognos 10.1

Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN

Databases: Oracle, DB2, Netezza, SQL Server

Programming languages: C, C++

Scripting: Unix Shell scripting, SQL stored procedures

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix

Sr.ETL Informatica Developer

Responsibilities:

• Extensively involved in almost all the phases of Project life cycle right from Requirements Gathering to Testing etc.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Actively involved in gathering requirements from the end users.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and sql server tables to target tables.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized the mappings and increased the re - usability
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Experience in using Debugger in Informatica Designer tool to test and fix errors in the mappings
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Worked with BIDW Admin Team for Code Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica Power Center 9.6, UNIX, DB2, Netezza, SQL Server

Confidential, Phoenix

Sr .ETL Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Actively involved in gathering requirements from the end users.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files, xml and RDBMS tables to target tables.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Schedule ETl loads using Control M.
• Resolve Critical and high incidents within time frame.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Checked and tuned the performance of application.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created RFCs and worked with BIDW admin team on Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica Power Center 9.1, Netezza,UNIX, Webfocus,IBM DB2, Xml, flat files

Confidential, Phoenix

Sr Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked on Power Center Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extracting,transforming and validating the data and loading the data into Stage Database Netezza And finally load the Data in to DB2.
• Extensively used transformations like Application source Qualifier, Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Created and scheduled Worklets, created many reusable tasks and used them in different Worklets and Workflows.
• Scheduled the Loading processes and monitored sessions using Informatica Workflow Monitor.
• Extensively worked in the performance tuning of mappings and sessions.
• Responsible for Testing and validating the Informatica mapping against the pre-defined ETL design standards.
• Created the Unit Test Plans and did Unit Testing, Prepare the Unit Test logs.
• Successfully moved the Mappings, Sessions and workflows from the Development environment to Production environment.
• Monitoring execution of implemented job in production during the warranty period and fix the identified issues.
• Provide knowledge transfer and process documents to Production Support for ongoing maintenance of the code.
• Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.

Environment: Informatica 9.1, DB2, UNIX Shell Scripting, Netezza

Confidential, Phoenix

Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked on PowerCenter Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extracting the data from Mainframe DB2 tables, transforming and validating the data and loading the data into Central Data Warehouse DB2 database.
• Designed, developed mappings, enabling the extract, transport and loading of the data into target tables.
• Extensively used transformations like Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Developed standard and reusable mappings and mapplets.
• Tuned the SQL queries used in the SQL override, Lookup Override of the Source Qualifier and Lookup transformations.
• Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions
• Created and scheduled Worklets, created many reusable tasks and used them in different Worklets and Workflows.
• Scheduled the Loading processes and monitored sessions using Informatica Workflow Monitor.
• Analyzing and modifying the existing PL/SQL Packages for performance tuning.
• Extensively worked in the performance tuning of mappings and sessions.
• UNIX Environment for running jobs through Control M.
• Responsible for Testing and validating the Informatica mapping against the pre-defined ETL design standards.
• Created the Unit Test Plans and did Unit Testing, Prepare the Unit Test logs.
• Successfully moved the Mappings, Sessions and workflows from the Development environment to Production environment.
• Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.

Environment: Informatica 8.6, DB2, UNIX.

Confidential

ETL Developer

Responsibilities:

• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area.
• Used heterogeneous data sources, like flat files and Oracle.
• Applied Complex Mappings and various Transformations (Filter, Router, Lookup, Update Strategy, and Expression) on the extracted data according to the Business Rules and Technical Requirements.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table.
• Creating reusable transformations and mappings using Informatica.
• Used debugger to test the data flow and fix the mappings.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks, created and monitored Informatica sessions.

Environment: Informatica PowerCenter 8.1, Oracle 9i, UNIX.

Confidential

ETL Developer

Responsibilities:

• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area.
• Worked extensively in Informatica in developing mappings and workflows.
• Created mappings according to the business rules.
• Good knowledge on using the debugger in case of any bugs.
• Created workflows and run the sessions using workflow designer.
• Creation of detail design documents and unit test plans.
• Unit testing and integration testing of mappings and workflows.
• Taken care Mandatory Checks, Date Field checks and Number Field Checks in Informatica

Environment: Informatica PowerCenter 8.1, Oracle 9i, UNIX.