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 noledge 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 wif Master Data Management (MDM)
• Working experience in Development, Enhancement and migration projects.
• Has 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,Bigdata and IBM DB2,SAP.
• Extensively worked on Designer, Repository Manager, Workflow Manager and Workflow Monitor using Informatica ETL Tool.
• Sound noledge in administration tasks including importing/exporting mappings, copying Workflow objects.
• Strong experience using Oracle, DB2, MS SQL Server, Netezza,Data Modular XML.
• Proficient in understanding business processes / requirements and translating them into technical requirements,Exposure on B2B process.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement teh business logics of database in Oracle.
• Experience in Unix Shell scripting and Perl Scripting and Linux.
• Worked wif 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 teh phases of Project life cycle right from Requirements Gathering to Testing etc.
• Involved in data design and modeling by specifying teh 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 teh 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 wif various transformations to solve teh 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 teh results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized teh mappings and increased teh re - usability
• Used transformations such as teh 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 teh mappings
• Responsible for creating shared and reusable objects in Informatica shared folder and update teh objects wif teh new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Worked wif BIDW Admin Team for Code Migration between Development, Test and Production Repositories.
• Supported teh Quality Assurance team in testing and validating teh 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 wif 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 teh 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 wif various transformations to solve teh 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 teh results in Workflow monitor.
• Schedule ETl loads using Control M.
• Resolve Critical and high incidents wifin time frame.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized teh mappings and increased teh re-usability
• Used transformations such as teh source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Checked and tuned teh performance of application.
• Responsible for creating shared and reusable objects in Informatica shared folder and update teh objects wif teh new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created RFCs and worked wif BIDW admin team on Migration between Development, Test and Production Repositories.
• Supported teh Quality Assurance team in testing and validating teh 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 InformaticaDeveloper

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 teh data and loading teh data into Stage Database Netezza And finally load teh 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 teh debugging of teh 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 teh Loading processes and monitored sessions using Informatica Workflow Monitor.
• Extensively worked in teh performance tuning of mappings and sessions.
• Responsible for Testing and validating teh Informatica mapping against teh pre-defined ETL design standards.
• Created teh Unit Test Plans and did Unit Testing, Prepare teh Unit Test logs.
• Successfully moved teh Mappings, Sessions and workflows from teh Development environment to Production environment.
• Monitoring execution of implemented job in production during teh warranty period and fix teh identified issues.
• Provide noledge transfer and process documents to Production Support for ongoing maintenance of teh 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 teh data from Mainframe DB2 tables, transforming and validating teh data and loading teh data into Central Data Warehouse DB2 database.
• Designed, developed mappings, enabling teh extract, transport and loading of teh 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 teh SQL queries used in teh SQL override, Lookup Override of teh Source Qualifier and Lookup transformations.
• Involved in teh debugging of teh 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 teh Loading processes and monitored sessions using Informatica Workflow Monitor.
• Analyzing and modifying teh existing PL/SQL Packages for performance tuning.
• Extensively worked in teh performance tuning of mappings and sessions.
• UNIX Environment for running jobs through Control M.
• Responsible for Testing and validating teh Informatica mapping against teh pre-defined ETL design standards.
• Created teh Unit Test Plans and did Unit Testing, Prepare teh Unit Test logs.
• Successfully moved teh Mappings, Sessions and workflows from teh 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 teh extracted data according to teh Business Rules and Technical Requirements.
• Created mappings using teh transformations such as teh 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 teh data flow and fix teh 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 teh business rules.
• Good noledge on using teh debugger in case of any bugs.
• Created workflows and run teh 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 Checksin Informatica

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