SUMMARY

• 8 Years of experience in Information Technology with a strong background in Data warehousing and ETL tools and technologies in various business domains
• Extensive experience in the Extraction, Transformation and Loading (ETL) of the data into the Data Warehouse using Informatica Power Center 9.1.0/8.6/7.1.5/6. x, Power Center Designer, Workflow Manager, Workflow Monitor and Repository manager.
• Expertise in Performance tuning measures in mappings, transformations, sessions. Solid knowledge in Identifying source, target and mapping bottlenecks.
• Experience inInformatica MetadataandRepository Management, was directly responsible for theExtraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Performed the data profiling and analysis making use ofInformatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Understanding of Informatica Power Exchange (PWX) and Metadata Reporter.
• Involved in identifying the business requirements and analyzing them in support of Data Warehousing (ETL) efforts.
• Good knowledge of Oracle RDBMS v11g/10g/9i with proficiency in writing SQL queries and PL/SQL Stored Procedures, Triggers, Packages, Cursors.
• Experience in Dimensional Modeling (Star schema, Snow - flake schema).
• Excellent knowledge in complete software development life cycle involving analysis, design, development, deployment, testing, documentation, implementation & maintenance of application.
• Strong Understanding existing business model and customer requirements.
• Designed Mapping Specifications on the basis of Functional Requirements to create the ETL Mappings.
• Extensively used Source Qualifier, Lookup, Router, Filter, Expression, Aggregate, Stored Procedure, Mapplet, Joiner, Update strategy and Union transformations.
• Developed reusable Mapplets and Transformations.
• Experience in writing UNIX scripts.
• Team player, self-starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica (Power Center 9.x/8.x/7.x/6.x),IDE, IDQ

Databases: Oracle 11g/10g/9i, SQL server, Teradata

Languages: HTML, XML,C, C++, Java, SQL, PL/SQL

Data Modeling Tools: Erwin

Operating Systems: Windows XP/2000/98/95, Unix

Scripting: UNIX shell scripting

Other tools: BO 6.5, TOAD, Autosys

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Informatica Developer

Responsibilities:

• Designed and developedInformatica Mappingsto load data from Source systemsand then toData Mart
• Extensively usedPower Centerto design multiple mappings with embedded business logic.
• Createdcomplex mappingsusing Sorter, Aggregator, Rank, Source Qualifier,Look up and Router transformations for populating target table in efficient manner.
• CreatedMappletsand used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning using round robin, hash auto key, Key range partitioning
• Managed Change control implementation and coordinating daily, weekly, monthly releases and reruns
• Applied reusable tasks and worklets in informatica that can be helped for easier design of workflows to implement the transformations that help movement of data from diversified sources to the target.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations
• Written UNIX Shell Scripts andPmcmdcommand line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 8.6.1/9.5.1, Workflow Manager, Workflow Monitor,Autosys, Oracle 10g/9i,Toad.

Confidential, NY

Sr.ETL Developer

Responsibilities:

• Worked as an ETL developer.
• Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL Design Documents, ETL Development, Testing and Support Activities.
• Responsible for design/development of Mappings & Transformation objects using Informatica PowerCenter.
• Scheduling Informatica batches and sessions to transport the data.
• Worked with the DBA group to create Informatica scripts to extract the historical data from one Sybase database into a datamart built in another Sybase database
• Created complex mappings in Power Center Designer using Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations. Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Performance tuning of the Informatica mappings using various components like Parameter files,Variables andDynamic Cache.
• Responsible for designing the data model & star schema.
• Developed plan to load the dimensional and fact tables into the Data Mart.

Environment: InformaticaPowerCenter9.5.1(Designer,WorkflowManager,Workflow Monitor,Repository Manager), Flat Files, Oracle 10, Windows XP.

Confidential

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from multiple databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center. Created the repository manager, users, user groups and their access profiles.
• ExtensivelyinvolvedinDataExtraction,TransformationandLoading(ETLprocess)from Source to target systems usingInformatica.
• Performed data cleansing and transformation using Informatica.
• WorkedextensivelywithDesignertoolslikeSourceAnalyzer,Transformation Developer, Mapping and Mapplet Designers.
• Created data mappings to extract data from different source files, transform the data using Filter, UpdateStrategy, Aggregator,Expression, JoinerTransformations andthen loadedinto target.
• Created variousUNIXShell Scripts for scheduling various data cleansing scripts and loading process.
• Developed various worklets as part of workflow design.
• Worked on optimization of mapping.

Environment: InformaticaPowerCenter8.6(Designer,WorkflowManager,Workflow Monitor,Repository Manager), Oracle 10g, Flat Files, Windows XP.

Confidential, NY

ETL Developer

Responsibilities:

• Responsible forDataExtraction,TransformationandLoading(ETLprocess)from Source to target systems usingInformatica.
• WorkedextensivelywithDesignertoolslikeSourceAnalyzer,Transformation Developer, Mapping and Mapplet Designers.
• Created data mappings to extract data from different source files, transform the data using Filter, UpdateStrategy, Aggregator,Expression, JoinerTransformations andthen loadedinto target.
• Implemented Slowly Changing Dimensions (SCDs, Type 2). Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Used Update Strategy Transformation to update the Target Dimension tables, type2 updates where we insert the new record and update the old record in the target so we can track the changes in the future.
• Used Workflow Manager to read data from sources, and write data to target databases and manage sessions.

Environment: Informatica PowerCenter 8.6(Designer, Workflow Manager,Monitor,Repository Manager), Oracle 10gWindows XP.

Confidential, NY

Informatica Consultant

Responsibilities:

• Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications.
• Involved in design and coding for various technical modules, building prototypes and integration of various modules of the software system.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Worked on database connections, SQL joins, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created Informatica repositories in different stages of project, which supports multi-language data (Unicode data) and created users, user groups and connections. Designed the mappings and sessions to extract Real-Time data from different systems.
• Created Simulation mappings, sessions and workflows for processing error records while loading into Informatica.
• Developed the JAVA components for the application.
• Responsible for generating automated test cases using Quality Test Professional.

Environment: Informatica PowerCenter 8.1.1(Designer, Workflow Manager,Monitor,Repository),Toad, Oracle 9i / 10g, Windows XP.

Confidential 

Team Member

Responsibilities:

• I was involved in design and coding for various technical modules, building prototypes and integration of various modules of the software system.
• Developed the User Interface using Java Swing APIs.
• Developed the module to interact with Microcontroller using C libraries.
• Providing the UAT support to the client.

Environment: Java,JDK, Swing, Oracle 8i.