Summary:

• 7 years of IT experience in analysis, design, development, implementation and troubleshooting in the area of Data warehousing.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 9.x/8.x/
• Expertise in building Enterprise Data Warehouses EDW , Operational Data Store ODS , Data Marts, and Decision Support Systems DSS using Multidimensional Model Kimball and Inmon , Star and Snowflake schema design addressing Slowly Changing Dimensions SCDs .
• Experienced with Data warehouse Project Life Cycle. Well versed with documenting all the phases of project SRS/FRD, DA specification, ETL specification, DMD, Unit Test Plan/Test cases.
• Good experience in designing and developing ETL Environment involving various Source and Target relational and non-relational databases such as Oracle, Teradata, SQL server, Flat Files fixed width , delimited and XML.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experienced in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Designed and developed Workflows, sessions and other tasks using Work flow manager tools Task Developer, Workflow Worklet Designer to handle different load scenarios.
• Experienced in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
• Good Knowledge on Teradata utilities bteq, Mload, tpump, Fastload and Fastexport.
• Expert in Database development that includes DML, DDL and DCL , PL/SQL that includes, procedures, Bulking techniques, collections, partitioned tables, stored procedures, functions, materialized views and performed query optimization, database performance and sqlloader.
• Worked in conjunction with reporting and Business Intelligence OLAP Tools such as OBIEE.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

Technical Skills:

Work Experience

Confidential

ETL Developer

Responsibilities:

• Designed and developed ETL mappings in Informatica designer using Source qualifier, expression, lookup and update strategy transformations based on the requirement.
• Performance tuned the ETL jobs and Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Generated daily trip report from the target ODS in order to determine the missing records from the source PeopleSoft system.
• Optimized and analyzed the target ODS objects periodically to enhance the performance.
• Created user accounts in order to provide access for the clients in production and testing environments.
• Worked and assisted the users with SQL queries in accessing the information from the target ODS on a daily basis.
• RPD Integration of PeopleSoft data into Financial Analytics, ETL Informatica, DAC.
• Build ETL to extract data from PeopleSoft source systems for new report development.
• Documented functional and technical specifications.

Environment: Informatica Power center 8.6.1, Oracle 10g, XML, PL/SQL, SQL Loader, UNIX, Erwin 7.0,Obiee.

Confidential

ETL Developer

Responsibilities:

• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Created and Scheduled Sessions Worklets using workflow Manager to load the data into the Target Database.
• Extensively involved in Reconciliation process and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively. Debugged the mappings developed by other developers.
• Tuned the performance of the mapping to load the data quicker.
• Worked with Materialized Views as Target to enable easy reporting
• Worked on design and development of Informatica mappings, workflows to load data into staging area and data marts.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Used FTP Process To transfer data feeds between environments.
• 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.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power center 9.1.1, Oracle 11g, XML, PL/SQL, UNIX, Erwin, 7.0

Confidential

ETL Designer/developer

Responsibilities:

• Worked and supported the design team in requirement gathering, data mapping and ETL specification design.
• Imported and analyzed the various file, relational sources and targets in source qualifier and target analyzer respectively.
• Analyzed the huge Omniture source feeds, live stream and VOD data for quality check and integrity of data.
• Designed and developed the mappings in the mapping designer using transformations source qualifier, expression, lookup and aggregator transformations as per the requirement.
• Developed the sessions around mappings, command tasks and worklets as per the requirement in task developer.
• Created the BTEQ scripts when the data is being loaded to target Teradata from a source Teradata database.
• Good experience with the Teradata Fast load and Mload utilities while loading the Teradata tables.
• Created the workflows by importing the required sessions and BTEQ scripts followed by scheduling of these workflows in ksh scripts.
• Transferred the files between various UNIX environments using ftp and sftp protocols.
• Worked on the scripts for creation and loading of the aggregate tables from the detail tables as per the customer requirement using aggregate database functions and these results are used to calculate the viewing time per session per customer.
• Performance tuned the ETL jobs and BTEQ scripts.
• Worked with the DBA for best performance practices in creation and dropping of indices on the right columns, stage tables and better query performance.
• Developed, tested and also reviewed the code with the team before migrating it to production.
• Provided BI On call support.

Environment: Informatica power center 9.1, Teradata 13.0, Oracle 10g, Flat files, Teradata SQL.

Confidential

ETL Developer

Responsibilities:

• Extracted data from various sources such as IMS Data, DB2 and Oracle.
• Extensively worked with IMS Data to validate Sample History module data.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources. Reporting and analyzing Business Objects tool.
• Worked on Web Intelligence-Access and report data through internet.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner and stored procedure. Created Pipeline partitioning to improve Session performance using round robin partitioning.
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Created and Scheduled Sessions Worklets using workflow Manager to load the data into the Target Database.
• Extensively involved in Reconciliation process and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively. Debugged the mappings developed by other developers.
• Tuned the performance of the mapping to load the data quicker.
• Worked with Materialized Views as Target to enable easy reporting.
• Developed Design documents and knowledge center for the modules developed.

Environment: Informatica Power Center, Oracle, SQL Plus, Toad, Windows, SQL Server, PL/SQL, ERWIN

Confidential

ETL Developer

Responsibilities:

• Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica.
• Importing Source/Target tables from the Flat Files, Oracle Databases and created reusable transformations and mappings using Designer Tool set of Informatica.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Preparing Technical specification document.
• Extensively Involved in Testing QA in preparing Unit Test cases and Test data.

Environment: Informatica Power Center 8.1, Oracle, Flat Files, Windows XP, UNIX