SUMMARY

• Over 7 Years of IT experience with Informatica tool.
• Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 8.x/9.x.
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica (Power Mart/ Power Center - Meta Data Repository, Designer, Server Manager).
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Experience in relational database development using PL/SQL and SQL in various relational databases like Oracle, SQL Server, and DB2.
• Experience in complex transformation load scripts.
• Experience in performance tuning the queries and Load processes.
• Experienced with different classes of ODS file systems extracted the files using ETL tool Informatica Power Center.
• Extensively worked with Informatica Data Quality (IDQ) for data analysis, cleansing, and data matching.
• Experience in ETL tools like Data stage and Data cleansing concepts.
• Experience in creating mappings, Mapplets and reusable transformations using Informatica.
• Worked with different data sources like Flat Files, XML files.
• Experience in UNIX Shell and Perl Scripts.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using Data Modeling tool Erwin.
• Design Source to Target maps, Version control, and Shared folders. SQL Override in the Source Qualifier and Lookup transformation.
• Worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Using Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Expert in implementing Type 1 and Type 2 Slowly Changing Dimensions as per the requirements.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0/8.0/7.1/ 6.2/6.1/5.1 (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets)

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5.2/3. x, Oracle Designer

Front-end tools: SQL Navigator 7.x

RDBMS: Oracle 10g/9i/8i, SQL, PL/SQL, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000

Environment: Windows 95/98/2000/XP, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential, Newyork

ETL Designer and Developer

Responsibilities:

• Develop complex transformation load scripts.
• Developed slowly changing dimensions.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Developed UNIX Scripts and SQL Queries.
• Developed ETL tools like Data stage and Data Cleansing concepts.
• Extensively worked with Informatica Data Quality for data analysis, cleansing, and data matching.
• Developed databases like Oracle and Sql server. Used SQL * Loader for bulk loading.
• Worked on Physical modeling phase in designing the Relational Database.
• Developed Unit test plans and integration test plans for verification and validations of procedure developed as well as to help validate the impact of changes.
• Involved in creating Technical Specification Document (TSD) for the project.
• Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Designed Reusable Transformations, Mapplets, Tasks and Worklets during Mapping and Workflow design process. Used most of the Power Center Transformations like Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator, Filter and Sequence Generator for loading the data into Oracle database.
• Performed Mapping, Workflow, SQL and Database tuning to improve system performance.
• Created and maintained Mapping Design and Testing documentation.
• Created and documented Test Plans. Performed Unit and Integration testing for Power Center Mappings and Workflows, and documented the findings.
• Participated in complete SDLC - requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests.

Confidential, Newyork

Informatica developer

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalize, rank and router transformations.
• Worked Informatics power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Complex transformation load scripts and Data Cleansing Concepts.
• Extensively used Informatica to load data from flat files, Oracle and Unix Scripting.
• Extensively used ETL tools like Data Stage.
• Performance tuning the Queries and load Processes.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed Re-Usable Transformations and Re-Usable Mapplets.
• Developed Slowly Changing Dimensions Mapping for Type 1 SCD and Type 2 SCD.

Confidential, Frisco, TX

ETL developer

Responsibilities:

• Extracted data from various heterogeneous sources like Flat Files.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor and repository Manager.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Extensively worked with various passive Transformations like Expression Transformation and Lookup Transformation.
• Developed database Schemas like Star schema and Snowflake schema used in relational, dimensional data modeling using ERWIN.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Involved in development of Informatica Mappings using transformations like Source qualifier, Aggregator, Connected & unconnected Lookups, Filter, Update Strategy, Rank, Stored Procedure, Expression and Sequence Generator and Reusable transformations.

Confidential

ETL designer and developer

Responsibilities:

• Created multiple Power Center Mappings (20+) and Power Center Workflows to accomplish data transformation and load process.
• Used various complex Power Center Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator, and Normalizer to accomplish the mapping design.
• Re-designed multiple existing Power Center mappings to implement change requests (CR) representing the updated business logic.
• Created User Defined Functions (UDFs) and reusable Mapplets and Transformations to simplify maintenance process and improve the productivity.
• Performed Unit Testing and Integration Testing of Mappings and Workflows.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Validated and fine-tuned the ETL logic coded into existing Power Center Mappings, leading to improved performance.
• Maintained technical documentation.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Used Debugger in troubleshooting the existing mappings.