SUMMARY

• 7+ years of experience in Data Warehouse/ETL procedure to load data from different sources into data warehouse using Power Center Designer, Workflow Manager and Workflow Monitor.
• Experience in Developing Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from various sources and load into target tables.
• Experienced in relational databases Oracle, SQL Server and Teradata.
• Knowledge of various phases of Software Development Life Cycle (SDLC).
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Involved in data migration and data quality check through ETL processes.
• Experienced in creating sessions in Workflow Manager and running the workflows in Workflow Monitor and analyzing them. Hands on experience in various Active and Passive transformations.
• Involved in import /export of existing mappings into different environments including Development, QA and Production.
• Experienced with different tools like Toad, SQL Navigator and SQL Developer.
• Ability to quickly understand existing business model and applications in order to perform reengineering to in corporate new business rules and functionality Highly adaptive to a team environment and capable of making performing tasks on an individual basis.

TECHNICAL SKILLS

Operating Systems: Windows 7/Vista/XP/NT/2000, UNIX, LUNIX.

Tools: Informatica 8.x/9.1, Cognos, Toad, MS Office, SQL Developer, Rational Clear Case, Clear Quest, Autosys Scheduler

Languages: SQL, PL/SQL, C++, UNIX Shell Scripting

Data Base: Teradata V2R6 (FastLoad, MLoad, TPump), Oracle 11g/10g/9i, MS SQL Server 2008, MS Access

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. ETL Informatica Developer/Consultant

Responsibilities:

• Interacted with Data Modellers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in creating mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Extensively used Informatica to load data from flat files, Oracle, Teradata database.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Worked on Autosys which involved in creation of Autosys jobs, execution
• Coordinated with Release Management team in getting our jobs executed in Test environment (Autosys)
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Environment: Informatica Power Center 9.5, Cognos 10.1, SQL Server 2012, Teradata 14.0 (MLOAD, FastLoad, TPump), PL/SQL, Oracle 10g/9i, Autosys, UNIX, Erwin, Quality Center.

Confidential, Providence, RI

Sr. ETL Informatica Developer/Consultant

Responsibilities:

• Using Informatica Power Center Designer analysed the source data to Extract & Transform from various source systems oracle, DB2, Teradata and flat files) to build an Operation Data Source.. Applied business logic to load the data into Enterprise Data Warehouse.
• Using Informatica Power Center created mappings and Mapplets to transform the data according to the business rules.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load the data.
• Monitoring, maintaining and scheduling Jobs in Autosys.
• Extracted data from various heterogeneous sources like Oracle, Teradata and Flat Files
• Developed Stored Procedures and used them in Stored Procedure transformation to build business rules to load the data.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Involved in completing the change request created by users. And also created the corresponding migration requests to move the changes from development to production environment
• Involved in Error Handling, Removing Bottlenecks, Performance Tuning, Query Optimization.

Environment: Informatica Power Center 9.1, PL/SQL, Teradata, Oracle 10g, UNIX,SQL Server 2010, Erwin 8.0, Cognos Series 10.1, Autosys, Windows NT

Confidential, DE

ETL Informatica Developer

Responsibilities:

• Extensively worked with Informatica to load data from flat files, Oracle, MS SQL server to target database.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence generator, Union and Update Strategy transformations while creating mapplets/mappings.
• Used PL/SQL to write stored procedures to increase the performance.
• Created Mapplets and used them in different mappings.
• Developed various sessions, batches containing parameter files, indicator files and multiple source files.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Involved in Designing Logical and Physical Data model using Erwin Tool Responsible for different Data mapping activities from Source systems to Teradata
• Writing JIL code to setup Box/Jobs in Autosys
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Designed, Developed, Reengineered and fine-tuned Oracle Stored Procedures and triggers
• Created mappings using Transformations such as Source qualifier, Aggregator, Expression, Connected and Unconnected Lookup, Filter, Router, Sorter, Stored Procedure, Normalizer,etc.
• Worked with team in preparing Source to Target Mapping and unit test case documents
• Designed, Developed and Reviewed ETL mappings from source to staging and from staging to Data warehouse
• Customized data by adding calculations, summaries and functions using various Transformations.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows
• Designed and documented the validation rules, error handling and test strategy of the mapping.

Environment: Informatica Power center 8.6.1, Oracle 9i, Toad, SQL, PL/SQL, Erwin and Windows NT, UNIX, Autosys.

Confidential, Scranton, PA

ETL Informatica Consultant

Responsibilities:

• Worked with Data Architects, Business Analysts and Independent Testing Team.
• Responsible for analyzing, programming and implementing modifications to existing systems required by changes in the business environment
• Provided technical documentation of Source and Target mappings
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple sources (flat files, HTML files, DB2, Oracle) to targets persistent data stores
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Source Qualifier, Expression, Stored Procedure and Update transformations
• Developed Shell scripts for initial conversion of dimensions, for validation of source files and data loading procedures, written multiple scripts for pre-processing the files.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse
• Designed and developed UNIX scripts and used AUTOSYS, Control-M for job scheduling.
• Performed other performance tuning techniques like reducing the number of transformations used in the mapping, using unconnected lookup when multiple values has to be returned from the same table, performing joins at the source level (homogenous sources) instead of using joiner transformation etc
• Used the Teradata external loading utilities like MultiLoad, TPUMP, FastLoad and FastExport to extract from and load effectively into Teradata database
• Worked on Data Partitioning that optimizes Parallel Processing with Multi Thread Processing
• Involved in Unit testing Interacted with QA team for system/integration testing
• Scheduled the Informatica Sessions and Batches based on Event based scheduling
• Used Debugger in troubleshooting the existing mappings
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Involved in writing scripts for loading data to target data warehouse for BTEQ, FastLoad and MultiLoad.
• Involved in Fine tuning SQL overrides and Look-up SQL overrides for performance Enhancements
• Worked on Pushdown Optimization and Partitioning at Session Level
• Extensively involved in parameterization of the workflow objects
• Executed sessions, sequential and concurrent batches for proper execution of mappings

Environment: Informatica 8.6, Teradata V2R6, Teradata Tools and Utilities, Data Quality, Windows Server 2008, DB2, AQT, Oracle 9i, Flat Files, Autosys, Unix shell scripting