SUMMARY:

• 7+ years of total experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Worked on various domains including auto and health Insurance, Finance, Retail.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Experience with ETL process using Informatica Power Center 9.x/8.x Power Exchange, B2B Data Transformation, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, Netezza, DB2 UDB, Teradata, MS SQL Server and Worked on integrating data from XML files, Mainframes files, flat files like fixed width and delimited.
• Experience in Object oriented programing using JAVA.
• Experience in Teradata for developing ETL and ELT architectures.
• Experience in the successful implementation of ETL solution between an OLTP and OLAP database in support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Worked with Informatica Data Quality 9.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Experience in identifying performance bottlenecks and tuning of Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
• Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.
• Extensively used SQL, T-SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Good experience in Data Cleansing, Data profiling, Data Quality and Data Analysis.
• Experience in using Exception Handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
• Experience in UNIX shell scripting, Scheduling tool Control M, and Autosys.
• Delivered all the projects/assignments within specified timelines.
• Experience in loading data into CRM tools like Microsoft CRM and Sales force using Informatica.
• Effectively communicate with business, project manager and team members.
• Experience in Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PROD environments, managing Users, Groups, associated privileges and performing backups of the repository.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.

TECHNICAL SKILLS:

Operating systems: Windows 8/7/2000/XP, UNIX, Linux.

Database: Oracle 10g/11g, SQL server, Teradata, DB2, MS Access

ETL Tools: Informatica 9.x/8.x/7.x (Power Center/Power Mart/Power Exchange) (Designer, Transformations, Workflow Manager, Workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplets) Power Analyzer, OLAP, OLTP, Informatica Data Quality (IDQ 8.6 8.6), Informatica MDM 9.5.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, and FACT & Dimensions Tables.

Data Modeling Tools: Erwin 4.0/3.5, TOAD, SQL Station, MS Visio, SQL Developer 

Other Tools: MS Visio, Crystal Reports, MS BI Development Studio

Programming Languages: SQL, PL/SQL, T-SQL

Scripting: Unix Shell scripting 

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer

Confidential, Bellevue, WA

Responsibilities:

• Involved in the complete Life cycle of the Project.
• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding and mapping. 
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager. 
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle. 
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager. 
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model. 
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool. 
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data. 
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0. 
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements. 
• Involved in Performance Tuning of mappings in Informatica. 
• Good understanding of source to target data mapping and Business rules associated with the ETL processes. 

Environment: Informatica 9.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.

Sr. ETL Informatica Developer

Confidential, Austin, TX

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Preparation of technical specification document for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
• Estimates and planning of development work using Agile Software Development.
• Good experience on Agile Methodology and the scrum process.
• Ensured performance metrics are met and tracked
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Involved in Data modeling review sessions - E/R diagrams, normalization and de-normalization as per business requirements.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management and Data transportation.
• Experience in Performance tuning of Source SQL queries and Teradata Queries.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems such as Oracle, Oracle GG, Flat files, XML, My Sql.
• Sourced transaction data being staged by Golden Gate tool CDC (Change Data Capture) through Informatica Power center and loaded into the target
• Worked on slowly changing dimension Type1 and Type2.
• Used the Teradata external loading utilities like MultiLoad, TPUMP, Fast Load and Fast Export to extract from and load effectively into Teradata database
• Worked on Web Service Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
• Configured tasks and workflows using workflow manager.
• Involved in the creation of Oracle SQL and PL/SQL stored procedures and functions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Tuned the Sessions for better performance by eliminating various performance bottlenecks.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Writing UNIX & Perl script to load data from sources to staging tables, to create indirect file list, generate parameter files for respective paths.
• Used SVN for version control and Autosys for Job scheduling.
• Applied Agile methodology throughout the development life cycle of application.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, Oracle Golden Gate, CDC, PLSQL, Teradata 14/13, Teradata Tools and Utilities, Autosys, My SQL, UNIX, Putty, Perl, MS Visio.

Informatica Developer

Confidential, Trenton, NJ

Responsibilities:

• Designing the source to target mappings that contain the Business rules and data cleansing during the extract, transform and load process.
• Responsible for converting Functional Requirements into Technical Specifications and production support.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Consultant, Mapplet Designer and Mapping Designer.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Utilized IDQ for data profiling, standardization and structuring the data.
• Tuned the informatica mappings for optimal load performance.
• Used Teradata utilities fast load, multi load, t pump to load the data.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Developed Oracle views to identify incremental changes for full extract data sources.
• Developed the automated and scheduled load processes using Tidal scheduler. Involved in migration of mappings and sessions from development repository to production repository.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Performed data integration from Informatica cloud into SAP & Salesforce cloud.
• Proficient in developing PL/SQL Stored Procedures, Packages and triggers to implement Business logic.
• Analysed, documented and maintained Test Results and Test Logs.
• Exposure on partitioning for loading large volumes of data.
• Scheduled Informatica workflows using Informatica Scheduler to run at regular intervals.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.
• Worked on Shell Scripts in order to convert incoming Excel Flat files from xls to csv, which helps importing into Informatica.
• Wrote Shell Scripting as a part of Ftp’ing the Files to the mainframe region.
• Actively participating in agile process development style like attending scrum meeting (standup meetings).
• Accepted inbound transactions from multiple sources using FACETS.
• Supported integrated EDI batch processing and real-time EDI using FACETS.

Environment: Informatica Power Center 9.5/9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Informatica IDQ, SQL Query Analyzer 8.0, Oracle 10g/11g, SQL Developer, Data Loader, OBIEE, BI Publisher, Erwin, Unix Shell Scripting, putty, FACETS and Business Objects.

ETL Developer

Confidential, Pleasanton, CA

Responsibilities:

• Involved in creating Detail Design Documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL specifications for development and conversion projects.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Designed complex ETL mappings and Oracle SQL scripts.
• Developed Informatica mappings, transformations, reusable objects by using mapping designer, and transformation developer and mapplet designer in Informatica Power Center.
• Created Reusable Transformations and Mapplets and used them in mappings.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Sequence Generator, Router, Update Strategy, Sorter, Normalizer, Lookup, Joiner and Stored procedure transformations.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business logic) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problems.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Experienced in performance tuning in Informatica.
• Coordinated with testing team to make testing team understand business and transformation rules being used throughout ETL process.
• Production & On Call Support.
• Involved in collection layer development.

Environment: Informatica 9.5.1/9.1.1 , Flat files, Oracle, DB2, Sybase, SQL, PL/SQL, UNIX, Windows.

ETL Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in system study, analysis of the requirements and designing of the complete system.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Responsible for verification of functional specifications and review of deliverables.
• Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.1.
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
• Created reusable transformations and mapplets to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Logical and physical Sybase database design in Erwin for data warehouse used by a securities lending application.
• Created repository, Groups, Users assigned privileges using repository manager.
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Worked with XML sources to get the data to Oracle to suite our environment.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Developed Unit test cases for all the jobs.
• Provided assistance during user testing.

Environment: Informatica Power Center 9.1.1/8.6, Oracle 9i/8i, SQL Server 2005, Sybase, PL/SQL, SQL Loader, Unix Shell Script, Windows.

ETL Developer

Confidential  

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Teradata as a source system

Environment: Informatica 8.1.1 Power Center, Teradata, Oracle 11g, Windows NT.