SUMMARY

• Over 5 years of experience in various Business Intelligence Tools such as Informatica, UNIX, DB2, Teradata, Autosys, MicroStrategy in Banking & Retail Domain
• Certified Informatica Designer/Developer (Cleared S, U, and R)/Certified in Oracle 9i (Introduction to Oracle)
• Good knowledge of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter 8.6/ (Workflow Manager, Workflow Monitor, Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer)
• Strong experience in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse and administrating the Informatica PowerCenter environment such as maintaining Informatica Repository and Server processes.
• Strong Data warehousing experience using Informatica Power Center 8.6. / 9.0
• Extensively used Informatica tools (Server and Client tools such as Admin console, Repository Manager, Designer, Workflow manager, Workflow Monitor)
• Experience wif UNIX shell scripting for File validation and SQL programming.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in implementing the complex business rules by creating transformation, re - usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Developed mappings using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Involved in all the phases Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation.
• Performing code migration from Dev to Test, using Deployment Group backup and restoring of Informatica Repository, upgrades, security administration and versioning.
• Monitored job execution on weekly basis in ESP workstation and performed validation of data as a part of Production support.

TECHNICAL SKILLS

Certifications: Certified Informatica Developer (cleared Informatica certification exams (S,U,R wif high scores)

Utilities: Informatica PowerExchange 8.6.1, MicroStrategy(Reporting Tool), ESP (Monitoring Tool),Autosys

Operating Systems: MS-DOS, Window XP/2000/NT, HP-UNIX

Domain Knowledge: Retail, Banking

Database tools: Teradata,DB2,TOAD PL/SQL Server 2005, 2000 SQL Developer 1.2

Databases: MYSQL, DB2, SQL Server, Oracle, Teradata

PROFESSIONAL EXPERIENCE

Confidential

Lead ETL Developer

Environment: Informatica Power Exchange 8.6.1 / 9, UNIX, Autosys, Teradata, DB2, Oracle 9i, Flat Files, Windows OS, Microsoft Excel, MS Office Word, Microsoft Project Plan

Responsibilities:

• Handling four independent tracks simultaneously.
• Involved in full project life cycle - from analysis to production implementation and support.
• Gatheird Requirements for functional and non- functional and provided solutions to the Design of the Project.
• Implement the Data governance rules provide by the business.
• Experience in task priorities to meet project timelines and identify project risks and handle multiple work related tasks.
• Create and execute unit test plans based on system and validation requirements Troubleshoot, optimize and tune ETL processes.
• Document all ETL related work per company's methodology and maintain existing code and fixed bugs whenever needed.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Create Mapplets and used them in different Mappings.
• Scheduled the mapping using Autosys Tool to run on specific dates/days.
• Use designer debugger to test the data flow and fix the mappings. Tuned Informatica mappings and
• Sessions for optimum performance. Provide detailed technical process and support documentation such as daily process rollback.
• Work wif mapping parameters and variables to load data from different sources to corresponding database table.
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Create SQL over ride in source qualifier, session partitions for improving performance.
• Perform unit testing and system testing of the mappings developed and documented wif various scenarios.
• Write UNIX Shell Scripting based on requirements and perform unit testing.
• Document standards for Informatica code development and prepared a handbook of standards.
• Schedule walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Work on Parameterize of all variables, connections at all levels in UNIX.
• Tune Informatica Mappings and Sessions for optimum performance.
• Developed complex mappings to implement type 2 slowly changing dimensions using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
• Extracted data from various environment source systems like Oracle, SQL Server, DB2, Flat Files.
• Developed common routine mappings made use of mapping variable & mapping parameters.
• Used Informatica Designer to create complex mappings using different transformations like Filter,
• Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Used Mapplets for use in mappings theirby saving valuable design time and effort.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and Workflows.
• Involved in UAT testing and migration of codes to UAT and PROD environment.

Confidential

ETL Developer

Environment: Informatica Power Exchange 8.6.1, UNIX, DB2, Oracle 9i, Flat Files, Microsoft Excel, MS Office Word

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support.
• Gatheird Requirements for functional and non-functional and provided solutions to the Design of the Project.
• Implement the Data governance rules provide by the business.
• Experience in task priorities to meet project timelines and identify project risks and handle multiple works related tasks.
• Create and execute unit test plans based on system and validation requirements Troubleshoot, optimize and tune ETL processes.
• Document all ETL related work per company's methodology and maintain existing code and fixed bugs whenever needed.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Create Mapplets and used them in different Mappings.
• Use designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and sessions for optimum performance. Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects wif the workflows and their dependencies.
• Work wif mapping parameters and variables to load data from different sources to corresponding database table.
• Production Support by monitoring ESP workstation and issue resolutions.
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Create SQL over ride in source qualifier, session partitions for improving performance.
• Perform unit testing and system testing of the mappings developed and documented wif various scenarios.
• Write UNIX Shell Scripting based on requirements
• Document standards for Informatica code development and prepared a handbook of standards.
• Schedule walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Work on Parameterize of all variables, connections at all levels in UNIX.
• Tune Informatica Mappings and Sessions for optimum performance.
• Developed complex mappings to implement type 2 slowly changing dimensions using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
• Extracted the data from the various environment source systems like Oracle, SQL Server, DB2, Flat Files.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Developed common routine mappings made use of mapping variable & mapping parameters.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Developed Slowly Changing Dimension for type I and type II (flag, date).
• Used Mapplets for use in mappings theirby saving valuable design time and effort.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and Workflows
• Production Support-Monitored the jobs in ESP workstation which run on weekly basis and was involved in validating the production data and resolving the production issues on weekly basis.

Confidential

Report Developer

Environment: MicroStrategy, UNIX, Oracle 9i, Microsoft Excel, MS Office Word

Responsibilities:

• Working experience as a single resource for the enhancement of existing reports in MicroStrategy.
• Part of entire development cycle: estimation, design, development, module testing and providing support to functional/integration testing team.
• Involved in the design, build and testing of schema objects such as: attributes facts, hierarchies, and transformations.
• Involved in the design, build and testing of public objects like metrics, filters, prompts and templates.
• Development of complex metrics wif level dimensionalities, transformation, filters etc.
• Development and testing of MicroStrategy reports and report service documents.
• Performance tuning of reports.
• Oracle Database - As a part of development and Testing in MSTR received good exposure to Oracle database.
• Wrote SQL queries for testing reports wif database.

Confidential

Data Warehouse/Informatica ETL Developer

Environment: Informatica Powercenter 8.6, MicroStrategy, Oracle 8i, UNIX Shell Scripts, TOAD, SQL * Loader

Responsibilities:

• Analyzed the systems, architecture, met wif end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data warehousing efforts.
• Developed ETL mappings, transformations using Informatica Powercenter 8.6.
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier, loading data from Staging area to DW.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in the Performance Tuning.
• Created and ran sessions and Workflows using Workflow Manager.
• Monitored the sessions and Workflows using Workflow Monitor.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Helped in generating reports using MicroStrategy.