SUMMARY

• Around 7 years of IT experience involving Data ware housing, ETL, Data Modeling, Development, Testing, Maintenance and Documentation.
• Experienced in analyzing business requirements and translating requirements into functional and technical design specifications.
• Practical understanding of database schemas like Star schema and Snow flake schema used in relational and dimensional modeling. Extensively worked on Erwin and Embarcadero data modeler tools.
• Extensive experience in Informatica Power Center 9.0 Designer (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer, Target Designer), Workflow Manager, Workflow Monitor and Repository Manager.
• Developed Informatica Mappings and Mapplets using various Transformations for importing data from Multiple Sources and implemented Type I and Type II Slowly Changing Dimensions (SCD’s).
• Very good experience using the Informatica Data Quality toolkit (IDQ) for performing Data analysis, Cleansing and Matching operations.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SSRS, SQL*Loader, Netezza.
• Strong experience in migrating Informatica jobs to production environment from Informatica Repository manager and workflow manager.
• Experienced in integration of various relational and non - relational sources such as DB2, Teradata, Oracle, SFDC, Netezza, SQL Server, COBOL, XML and Flat Files,
• Experienced in Performance tuning of mappings, identifying and resolving performance bottlenecks in various levels like source, targets, mappings and sessions.
• Strong experience in coding database scripts such as SQL queries and database objects such as PL/SQL Packages, Stored procedures, Indexes, Functions, Views and Triggers.
• Very good experience on OBIEE Administration Tool, Answers, Intelligent Dashboards and Repository (rpd) development.
• Used HP Quality Center 10 for logging and fixing the defects in System testing and Integration testing phases.
• Proficient in using Tidal, CTL-M, Autosys and UNIX shell scripting for job scheduling and monitoring on multiple platforms like Windows 2000, XP and Unix environments.
• Experienced in using version control tools like Tortoise CVS and PVCS.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/ 9i/8i, Netezza4.6.8, SQL Server 2008, SSRS, DB2 V8.1, Data Stage, Teradata V2R 5.0

ETL tools: Informatica Power Center 9.0, 8.6.1/8.1.1/7.1 , Informatica Data Quality, SQL*Loader

Reporting tools: (OBIEE) 10.1.3.3.3

Operating systems: Unix, Windows XP/2000/7

Data modeling: Erwin 4.1/4.0/3.5.2 , Embarcadero ER Modeler

Languages/utilities: SQL, PL/SQL, Perl, Unix scripts, Autosys, CTL-M, Tidal, C, C++, XML &J2EE

Other tools: Toad 7.0, SQL Server Management Studio 2008, DAC 7.9, Embarcadero Rapid SQL 7.6, Teradata SQL Assistant 7.2, BTEQ, HP Quality Center 10

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr Informatica Developer

Responsibilities:

• Working closely with system architects, business analysts and QA to understand the requirements and translate requirements into functional and technical specifications.
• Followed Agile methodology in developing ETL process and participated in daily scrum, sprint planning and sprint retrospective meetings
• Created the test cases and test plans for user acceptance testing for QA and system testing based on functional Specifications.
• Extensively used Informatica Power Center 9.0 and worked on client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager to develop mappings, sessions, and workflows.
• Created standard and best practices for Talend ETL components.
• Extracted data from heterogeneous sources like Flat files, XMLs, Oracle,DB2, SFDC and SQL server for loading data into relational system.
• Generated various outbound extracts in XML, CSV and pipe delimited format for Pharmacy and Q2C teams.
• Implemented error reporting for conversion team for generating conversion reports.
• Creating complex mappings in Power Center Designer 9.0 using Aggregate, Expression, Filter, Router, Update Strategy, Union, Lookup, Joiner, XML, Normalizer, Picklistand Stored procedure transformations.
• Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Worked with NZ Load to load flat file data into Netezza tables.
• Implemented Informatica recommendations, methodologies, best practices and provided support in developing the datamart schema.
• Performed unit testing and system testing of Informatica mappings, sessions and workflows to find defects in the code. Tracked and assigned these defects by using HP ALM tool.
• Extensively used utilities such as TOAD and Surveyor to develop, test and debug SQL and PL/SQL scripts, packages, procedures and functions.
• Identified areas where performance bottlenecks exists and implemented performance tuning measures at Informatica mapping and session levels.
• Created change requests, application turnover documents for production support teams and coordinated with them in migrating the Oracle and Informatica code into production region.
• Scheduled Informatica jobs and events in Tidal scheduling tool and created job dependencies as per business process flows.
• Assisted the production support team in troubleshooting the failed jobs in Production regions.

Environment: Informatica Power Center 9, Oracle 11g, Netezza4.x, SQL Server 2008, SSRS, Talend, Toad 7.0, Surveyor, Data Stage,Tidal, UNIX, HP quality center 9 and Undraleu

Confidential, Dublin, CA

Informatica Developer

Responsibilities:

• Actively participated in the design phase such as gathering the user requirements and provided optimal solution to address various technical issues.
• Estimated the work effort for the ETL process and worked with offshore team to communicate the requirements and address any development issues.
• Created technical specification document (TSD) and informatica mapping documents for ETL process based on functional requirements specified in Functional Specification Documents(FSD)
• Extracted data from flat files and oracle database, applied business logic to load them into PMA (Performance Measurement and Attribution) datamart
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations
• Worked on different data sources such as Oracle, SQL Server, XML, Flat files etc to create flat file, XML extracts and load data into relational databases.
• Performed unit testing and system testing of Informatica mappings, sessions and workflows to find defects in the code. Performed defect triage using HP Quality Center 9.
• Created database objects such as Packages, Stored Procedures, Functions, Exceptions and Cursors to extract data from sources and perform business calculations.
• Implemented Error handling at database level by using procedures and exceptions to capture the error codes and error messages into error table that occur while data is loaded into the target tables.
• Identified areas where performance bottlenecks exists and implemented performance tuning measures at Informatica mapping and session levels.
• Implemented Informatica recommendations, methodologies and best practices.
• Used CTL M scheduling tool for scheduling Informatica and DB jobs.
• Created Merge notes for code integration and updated game plan document to schedule new jobs in the game plan.
• Assisted the production support team in troubleshooting the failed jobs in Production server.

Environment: Informatica Power Center 8.6, Oracle 11g SQL and PL/SQL, SSRS, SQL Server 2008, Data Stage, Toad 7.0, CTL M UNIX and HP quality center 9.

Confidential, CO

Informatica Developer

Responsibilities:

• Involved in gathering business requirements in liaison with business users and technical teams. Created requirement specification documents and identified data sources and targets.
• Used relational sources and flat files to populate the data mart. Translated the business processes into Informatica mappings for building the data mart.
• Coordinated with the offshore team for reviewing the ETL code and provided development support.
• Worked with various Informatica Server and Client tools like Designer, Workflow Manager, Workflow Monitor and Repository manager.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner and Sequence generator.
• Used Normalizer transformation for importing and working with COBOL files.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Used Update Strategy Transformation and configured the mappings to handle the updates, to preserve the existing records.
• Created tasks, sessions, worklets and workflows in the Workflow Manager and gathering status updates using Workflow Monitor.
• Involved in dealing with performance issues at various levels such as target, sessions, mappings and sources.
• Involved in fixing invalid Mappings and performed Unit testing and Integration Testing.
• Involved in customizing the Physical Layer, Business Model & Mapping Layer and Presentation Layer in Analytics Repository (RPD) using OBIEE Administration Tool.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts in OBIEE Answers to design the dashboards.
• Created PL/SQL stored procedures to perform data validation on the business data.
• Developed UNIX shell scripts to automate the data warehouse loading.

Environment: Informatica Power Center 8.1/8.5,OBIEE 10.1.3.3, Oracle 9i/10g, PL/SQL, SSRS, Data Stage, TOAD 8.6, Embarcadero Data modeller SQL *plus, UNIX, Windows XP.

Confidential, TX

Informatica Developer

Responsibilities:

• Worked with Business analysts and DBA for requirements gathering and designing of data mart.
• Designed and developed ETL (extract, Transform and Load) strategy to populate the data ware house from various source systems such as Oracle, Flat files etc. feeds using Informatica Power center.
• Extensively worked on Power center designer (Source analyzer, Warehouse designer, Transformation developer, mapping designer, and mapplet designer).
• Extensively used transformations like Aggregator, Joiner, Router, Expression, Lookup, Update strategy and Sequence generator.
• Created mappings to load slowly changing dimension tables based on amount of historic dimension data needed to be present.
• Tuned the sessions for better performance by eliminating various performance bottlenecks.
• Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects in OBIEE Administration tool.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Involved in the development of PL/SQL stored procedures and functions to process business data.
• Involved in Data modeling using Star Schema methodology and created data models using Erwin.

Environment: Informatica Power Center 7.1.3, OBIEE 10.1.3.2, Oracle 8i, Erwin 4.1, TOAD 8.6, SQL *PLUS, PL/SQL, Shell scripts, Data Stage, UNIX.

Confidential

Informatica/PLSQL Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation
• Developed complex mappings using Expressions, Aggregators, Filters, Lookup, Stored Procedure transformation, Joiner, Normalize, Router, and Sorter transformation logic to generate consolidated data needed for EDW
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Designed and Developed Stored Procedures, Packages & Functions using PL/SQL and SQL scripts.
• Extensively developed complex PL/SQL packages for ETL
• Developed Informatica Mappings to load data into Data Mart
• Used Workflow Monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Developed UNIX shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power Center 6.2, Oracle 9i, SQL, PL/SQL, SQL *PLUS, SQL*Loader and Windows 2000 .