SUMMARY

• Over Eight years of experience in the field of Information Technology, with extensive experience in analysis, design, development, data conversion, Data Warehouse, Data Mart design, Unit testing and documentation.
• Extensive experience on Informatica Power Center 9.5 /9.1 / 8.6
• Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies.
• Have experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLTP/OLAP systems.
• Experience in database design, Entity-Relationship modeling and Dimensional modelingusing ERWIN.
• Expertise in creating tables, triggers, macros, views, stored procedures, functions, Packages in Teradata database.
• Strong knowledge on Teradata architecture and Teradata data distribution for PI, NUSI, USI and NUPI.
• Excellent Experience with different indexes PI, SI, JI, AJIs, PPI and Collect Statistics.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Implementing complex Business rules by creating mappings, mapplets, reusable transformations, Workflows and Worklets using Informatica Power Center.
• Worked on Slowly Changing Dimensions SCD's and its implementation to keep track of historical data.
• Extensive experience in databasetechnologies Creating tables, views,indexes, triggers, complex SQL queries, Stored Procedures and performingSQL tuning
• Proactively monitor and optimize query performance, session performance and fine tuning the mappings.
• Strong Quality Assurance, debuggingand performance tuningskills in ETL Process and hands on experience in troubleshooting and handling production support jobs.
• Extensive experience in end to end ETL design, documentation, development, testing and client support Implement Unix shell scripts for scheduling various tasks.

Technical Skills:

Work Summary

Confidential

ETL Developer

Responsibilities:

• Worked closely with Business Analyst and the end users for understanding existing businessmodel and customer requirements and involved in preparing the functionalspecifications based on the business requirement needs.
• Worked closely with Dataarchitect to build dimensionalModels.
• Worked on Kimball Methodology.
• Involved in end to end ETL required to build the customer billingdatamarts.
• Responsible for developing the ETL Extract, Transform and Load processes using Informatica power center.
• Worked extensively on Informatica Power Center using Transformation Designer, Mappingdesigner, WarehouseDesigner.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter,SequenceGenerator, UpdateStrategy, Union, Lookup, Joiner, XMLSourceQualifier and Storedproceduretransformations.
• Developed numerousInformaticamappings to load stage, dimension and fact tables.
• Developed mappings to implement Slowly Changing Dimensions Type 1 2 .
• Worked on performancetuning of Informatica objects and on Teradata complex SQL queries.
• Used Teradata utilities Fastload, Multiload, Tpump to load data.
• Extensively used Teradata parallel capability through TPT Teradata Parallel Transporter utility.
• Wrote Fastexport script to export data.
• Wrote TeradataMacros and used Teradata analytic functions.
• Implemented Teradata Fastload, Multiload and BTEQ scripts, DML and DDL.
• Created Teradata External loader connections such as MLoad, Upsert and Fast Load while loading data into the target tables in Teradata Database.
• Worked on shellscripts to handle flatfiles which include files from source system and transferring files to downstream systems.
• Performed Unit Testing. Involved in User Acceptance Testing.
• Involved in Peerreviewsof the Designdocument as well as code walkthrough.
• Involved in Reviewing of Checklists and ProjectDeliverables.

Environment:Informatica power center 9.1, Oracle 11g, windows 8, PL/SQL, SQL LOADER, TOAD, LINUX, Teradata 13, BTEQ , Teradata Utilities

Confidential

ETL Developer

Responsibilities and Roles:

• Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
• Involved in analyzing the requirements and created Design Documents and Data Mapping Documents.
• Involved in databasedevelopment by writing PL/SQL Stored Procedures, triggers, views, joins.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
• Used Mapping Parameters and Variables to implement object orientation technologies and facilitate the reusability of code.
• Designed the ETL processes using Informatica to loaddata from Oracle, SQL Server, Flat Files, Fixed Width , XML files and Excel files to target Teradata Database.
• Worked on Informatica to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Implemented performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Knowledge on TPT utility helped me to implement Teradataparallelload and export effectively.
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and BTEQ scripts, DML and DDL.
• Wrote TeradataMacros and used various Teradata analyticfunctions.Used Teradata utilities fastload, multiload, tpump to load data.
• Writing BTEQ Basic Terradata Query scripts.
• Implemented various Teradata specific features like selection of PI, USI/NUSI, PPIand Compression based on requirements.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.

Environment:Informatica Power Center 9.0,Oracle 11g, SQL Server, Flat files, Linux, Teradata, MLOAD, TPUMP, FAST LOAD, FAST EXPORT

Confidential

ETL Analyst

Responsibilities:

• Responsible for designing and developing the Informaticamappings for data loads.
• Developed Parameter files for DataIntegrity.
• Used almost all of the transformations of Informatica including lookups, UpdateStrategy, Union, Sorter, Router and others.
• Mapplets and ReusableTransformations were used to prevent redundancy of transformation usage and maintainability.
• Worked with Informatica Best Practicesguidelines to minimize performance issues.
• Scheduled, Executed and Monitored sessions by using InformaticaWorkflow Manager.
• Responsible for weekly statusupdates showing the progress of developmentlifecycle.
• Involved extensively in conducting integration, performance and UAT testing.
• Used Teradata utilities Fastload, Multiload, Tpump to load data
• Wrote Fastexport script to export data.
• Wrote TeradataMacros and used Teradata analytic functions.
• Expertise in OraclePL/SQL helped me in developingcomplex queries to validate tables for accurate data population.
• Created Tasks such as session which contains the mapping which is built in the designer and email using Workflow manager tool like Task Developer.

Environment: Informatica, ORACLE 10g , PL/SQL, SQL, Import/Export, SQL Loader, Informatica Power Center 8.6, Cognos Report Net, TOAD Quest Software, Windows XP, UNIX, Teradata

Confidential

ETL Developer

Responsibilities and Roles:

• Responsible for design, development, enhancement of Informatica mappings.
• Creation of Transformations like Lookup and Source Qualifier Transformations in the Informatica Designer.
• Created various other Transformations like Aggregate, Expression, Filter, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Involved in creation of Stored Procedures and tested in development and staging environment
• Tuning Informatica Mappings and Sessions for optimum performance.

Environment:Informatica Power center 8.6, Oracle, SQL, PL/SQL, and Windows XP.