SUMMARY

• Over Seven 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 8.6/9.1/9.5
• Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies.
• Experience in database design, Entity-Relationship modeling and Dimensional modelingusing ERWIN.
• Extensively 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.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, reusable transformations, Workflows and Worklets using Informatica Power Center.
• Expertise in data extraction from Flat Files XML, excel, csv, fixed width, delimited, txt, Access-mdb , SQL-Serverand Oracle ERP.
• Experience in implementing the complex business rules by creating transformation/re-usable transformationssuch as Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy, Stored Procedure Transformation and developing complex Mapplets and Mappings.
• Worked on Slowly Changing Dimensions SCD's and its implementation Type1 and Type 2 to keep track of historical data.
• Extensive experience in databasetechnologies over 6 years Creating indexes, tables, views,CTE, triggers, complex SQL queries, Stored Procedures and performingSQL tuning
• Proactively monitor and optimize query performance, session performance and fine tuning the mappings.
• Experience in Installation, Configuration of Informatica Power Center.
• 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 LINUX shell scripts for scheduling various tasks.
• Created reports using Tableau

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.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica power center.
• Worked closely with Dataarchitect to build dimensionalModels.
• Involved in end to end ETL required to build the customer billingdatamarts.
• Worked extensively on Informatica Power Center using SourceAnalyzer, Mappingdesigner, WarehouseDesigner.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and SequenceGenerator, UpdateStrategy, Union, Lookup, Joiner, XMLSourceQualifier and Storedproceduretransformations.
• Developed numerousInformaticamappings to loads stage, dimension and fact tables.
• Developed mappings to implement Slowly Changing Dimensions Type 1 2 .
• Created reusable transformations and mapplets.
• Worked on performancetuning of Informatica objects.
• Used Teradata utilities fastload, multiload, tpump to load data
• Writing BTEQ Basic Terradata Query scripts.
• Writing PL/SQLprocedures days of supply for processing business logic in the Database.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Extensively used SQL Loader to load Data from flat files to Database tables In Oracle.
• 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 Peerreviews of the Designdocument as well as code walkthrough.
• Involved in Reviewing of Checklists and ProjectDeliverables.
• Worked in Agile Scrum Methodologies

Environment: Informatica power center 9.1, Oracle 11g, windows 8, PL/SQL, SQL LOADER, TOAD, LINUX, Autosys Scheduler, Teradata

Confidential

ETL Informatica 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.
• Worked with Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Workflow Manager and Monitor.
• 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.
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Involved in databasedevelopment by writing PL/SQL Stored Procedures, triggers, views, joins.
• Used Teradata utilities fastload, multiload, tpump to load data
• Writing BTEQ Basic Terradata Query scripts.
• Writing PL/SQLprocedures days of supply for processing business logic in the Database.
• Carried out performance tuning both on Informatica side and database side.
• Expertise in creating databases, tables, triggers, views, storedprocedures, functions, joins and hashindexes in Teradata database.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• 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.
• Created reports using Tableau

Environment: Informatica Power Center 9.0, 8.6, Microsoft SQL Server 2012/2008, PL/SQL, SQL Developer, Oracle 10g/9i/8i, TOAD 7.0, Flat files, XML, Linux,Teradata, Tableau

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 Informatica Workflow 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.
• Involved in DBI Daily Business Intelligence , Oracle 11i Upgrade, Oracle Security Patches, Application Infrastructure Upgrade, Purchasing and Contract Reporting.

Environment: Informatica, ORACLE 9i/10g/11i, Siebel, 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 center7.x,8.6, Oracle 8i, SQL, PL/SQL, and Windows XP.