PROFESSIONAL SUMMARY:

• 9 years of data - warehousing/ETL/Teradata experience in the Business Requirements, Analysis, Design, Development, Data Exchange and Implementation and Testing of Data warehouse/Data Mart systems.
• Expert knowledge in using Power Center tools - Mapping Designer, Workflow Manager and Workflow Monitor, Repository Manager, Admin console.
• Excellent knowledge of Data warehousing and Business Intelligence Concepts like Star Schema, Snowflake Schema and slowly changing dimensions, with emphasis on ETL implementations, making data readily available for reporting needs of end users.
• Extensively worked on Data migration, Data cleansing, Data Staging of operational sources, CDC using ETL.
• Experience in Performance tuning and Error Handling techniques and debugging ETL components using Informatica debugger.
• Proficient in implementing complex business rules through transformations (Expression, Aggregator, Filter, Lookup, Router, Joiner, Update Strategy, Normalizer), reusable components (transformations, mapplets, sessions, worklets) in Informatica.
• Expert in Data Extraction and integration of heterogeneous Data Sources such as Oracle, DB2, Teradata, MS SQL-Server, Salesforce.com, Siebel-CRM, Mainframes, Web Services, Flat files.
• Worked on coding and fine tuning SQL scripting, PL/SQL Stored Procedures
• Excellent problem solving, communication, leadership, analytical and interpersonal skills working independently or as part of a team, highly effective at communicating with all levels of management and coworkers.
• Experienced using SQL scripting, TSQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.
• Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
• Implement PL/SQL requirements or rules into the ETL tool.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Identified gaps and risk in the process and automated reports using VBA resulting in 100% accuracy, time saving and risk reduction.
• Strong communication skills and excellent experience in working with small and big teams under stringent timelines.
• Involved in unit level, integration and system testing.
• Familiar with Waterfall and Agile methodologies and familiar with all the stages of SDLC & STLC.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange 8.6.1, MDM, IDQ 9.5

Databases: SQL Server, DB2, Oracle 11g/10g, Teradata R15, R13, R12

Languages: SQL, PL/SQL, Teradata SQL, Java, VBA Teradata tools Utilities query facilities: SQL Assistant, Visual Explain, Index Wizard, View point

Testing Concepts: SDLC, STLC, Testing Levels, Testing Types

Scheduling Tools: Autosys, Control M

Reporting tools: Business Objects, Digital Fuel

Automation Tools: QTP10.0

Tools: HP Quality Centre, ALM

Microsoft Office: Word, Excel, Power Point, Access, SharePoint 07

Operating Systems: Windows XP/2000/Vista, 7, UNIX

WORK EXPERIENCE:

Confidential, Plano, TX

Senior Informatica Developer / Analyst

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files and loading into DataMart.
• Creating the detailed design documents and 1-1 mapping documents.
• Developed complex mapping logic using various transformations like Expression, Lookups Joiner, Filter, Sorter, Router, Update strategy and Sequence generator
• Converted functional specifications into technical specifications.
• Created complex Informatica mappings to implement Change Data Capture mechanism by using Type-2 effective date and time logic.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
• Built mapplets and integrated with dashboard where the business users can see the fail records and pass records in bars and charts view based on each rule or field.
• Created adaptors, flows, reports and dashboards to populate the reports using the Digital Fuel reporting tool.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, and IIF function.
• Effectively communicated with the Business Partners and team members, the problem and the expected time resolution.
• Responsible for providing timely feedback and necessary help/cooperation to meet client expectations
• Created Unix scripts as it is a new application
• Documented existing mappings as per standards and developed template for mapping specification document.
• Collaborated with tidal team in setting up dependencies on various mappings.
• Preparing implementation plan for moving the code to production such as pre implementation, post implementation and back out plan.
• Perform Unit and Integration testing. Reporting of bugs and bug fixing.
• Preparing Rollout Plan to knowledge transfer the Production support team and support the application during the hyper care.

Confidential, Plano, TX

Senior Informatica Developer / Analyst

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files and loading into DataMart.
• Creating the detailed design documents and 1-1 mapping documents.
• Developed complex mapping logic using various transformations like Expression, Lookups Joiner, Filter, Sorter, Router, Update strategy and Sequence generator
• Converted functional specifications into technical specifications (design of mapping documents).
• Created complex Informatica mappings to implement Change Data Capture mechanism by using Type-2 effective date and time logic.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on creating PL/SQL, Stored Procedures, Database Triggers, Views, performance tuning and optimization.
• Built mapplets and integrated with dashboard where the business users can see the fail records and pass records in bars and charts view based on each rule or field.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, and IIF function.
• Effectively communicated with the Business Partners and team members, the problem and the expected time resolution.
• Responsible for providing timely feedback and necessary help/cooperation to meet client expectations
• Created Unix scripts as it is a new application
• Documented existing mappings as per standards and developed template for mapping specification document.
• Preparing implementation plan for moving the code to production such as pre- implementation, post implementation and back out plan.
• Worked with other team member on business objects.
• Perform Unit and Integration testing. Reporting of bugs and bug fixing.
• Preparing Rollout Plan to knowledge transfer the Production support team and support the application during the hyper care.

Confidential

ETL-Informatica Developer

Responsibilities:

• To understand and analyze the requirement documents and explaining them to team whenever and wherever necessary.
• Design and creation of detailed Technical Mapping document with information on implementation of business logic.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Prepare Unit and Integration test cases.
• Extracted data from various source systems like Oracle and flat files as per the requirements.
• To design Informatica mappings by using various basic transformations like filters, routers, source qualifiers, lookups etc. and advance transformations like aggregators, XML source qualifiers, sorters etc.
• Building reusable components include reusable expression, mapplets, sessions and flows to facilitate flexible portfolios.
• Create workflows and set the session dependencies.
• Worked extensively with aggregate functions like Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Worked with various re-usable tasks, workflows, mapplets, and re-usable transformations.
• Worked with Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer
• Perform Unit and Integration testing. Reporting of bugs and bug fixing.
• Used session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.
• Worked with the third party for Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager.
• Facilitate QA testing and creating the high level QA test document.
• Acting as an onsite coordinator and working together with teams in different locations.

Confidential

ETL-Informatica Developer

Responsibilities:

• As an ETL Developer, gathered business requirement and implementing their business needs.
• To design Informatica mappings by using various basic transformations like filters, routers, source qualifiers, lookups etc. and advance transformations like Aggregators, Normalizers, XML source qualifiers, sorters etc.
• Create workflows and set the session dependencies.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Develop UNIX shell script to perform file cleansing, archiving the file, creating a parameter file, Data Exchange etc.
• Tuning the transformations, mappings and sessions for performance enhancements.
• Worked on coding and fine tuning SQL scripting, PL/SQL Stored Procedures
• Done migrating data from MySQL to SQL server and MongoDB
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Developed mappings/sessions using Informatica Power Center for data loading.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.x.
• Preparing implementation plan for moving the code to production such as pre implementation, post implementation and back out plan.
• Preparing Rollout Plan to knowledge transfer the Production support team and support the application.
• Perform Unit and Integration testing. Reporting of bugs and bug fixing.

Confidential

ETL-Informatica Developer

Responsibilities:

• Design the mapping to populate the data from different sources to oracle database.
• Testing, debugging the data loading for full and incremental Loads.
• Optimizing/Tuning mappings for better performance and efficiency.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, Rank, Router etc. of Informatica.
• Involved in writing the test cases for Unit Testing.
• Review the documentation and coding created by other team members.
• Responsible for design the High-level technical design & detailed ETL design.
• Defining Data Movement standards for data warehouse from different application
• Resolving if any issues in transformations and mappings during the development, Data Exchange and bug fixing
• Change request creation and additional requirement documenting to the same and Validation of test scripts
• Responsible for facilitating the business users for integration and UAT
• Worked on issues identified during the post production issue tracking meetings held with the business users and Monitoring and tracking those issues to closure.
• Participating in the project status meeting and providing track status as of date

Confidential

ETL Consultant

Responsibilities:

• Worked with various Informatica client tools such as Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Implemented weekly error tracking and correction process using Informatica.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in unit testing, user acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Developed the DDL’s, DML’s, PL/SQL stored procedures, indexes and for ETL operations on Oracle, and SQL server databases.
• Involved in developing test data/cases to verify accuracy and completeness of Data Exchange and ETL process.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.