SUMMARY:

• Over 7+ years extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading Data using Informatica PowerCenter/IDQ.
• Involved in the Analysis, Design, Development, Testing and Implementation of business application systems for various Sectors.
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 etc.
• Extensively used Informatica PowerCenter 9.6/9.1/8, Informatica Data Quality (IDQ) 9.6/9.1 as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
• Strong work experience in Data Warehouse life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, Mainframe, Teradata and flat files into data marts and data warehouse using Informatica Power Center - Designer, Workflow Manager, and Workflow Monitor.
• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Strong understanding of OLAP and OLTP Concepts.
• Experience in SQL, PL/SQL and UNIX shell scripting. Worked on Informatica Data Quality 9.6/9.1(IDQ) tool kit and performed data profiling, cleansing and matching and imported data quality files as reference tables.
• Solid experience in writing SQL queries and Stored Procedures.
• Good knowledge on data quality measurement using IDQ and IDE.
• Good experience in Informatica Installation, Migration and Upgrade Process.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Extensive experience using database tool such as SQL *Plus, SQL.
• Experience in using Informatica Utilities like Pushdown optimization, Partition and implemented slowly changing dimensions Type1, Type2 methodology for accessing the full history of accounts and transaction information.
• Expertise in Data Flow Diagrams, Process Models and ER diagrams with modeling tools like ERWIN r 7/4/3.5 & MS VISIO 2007/2010
• Very good experience in heterogeneous data sources and integrating their data in target data warehouse layers.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• Worked extensively in team-oriented environment with strong analytical, interpersonal and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.1/8.x/7.x/6.x, Power Exchange 9.1/8.x/7.xInformatica Data Quality, Power Mart 5.x (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformation Developer, Repository Manager, Workflow monitor).

Data Modeling: MS Visio, ER Diagrams.

Databases: Oracle 12C/11g/10g/9i/8i, Sybase, DB2, MS SQL Server 2000/2005, Teradata.

DB Tools: Oracle SQL Developer, SQL*Loader, Toad, Oracle SQL*Plus.

Operating Systems: Windows 98/2003/2000/ XP/7/NT, UNIX, MS-DOS.

Scheduling Tools: Informatica Scheduler, Autosys, Control M, DAC.

Languages: SQL, PL/SQL, UNIX, HTML, XML, C, C++, Java.

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Methodologies/Data: Modeling Tools Data Mart, Dimensional, Snowflake, Star Schema, ERWIN.

Other Tools: Tableau, UML Tools.

PROFESSIONAL EXPERIENCE:

Senior Informatica Developer

Confidential, St. Louis, MO

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica PowerCenter.
• Experienced in Parsing high-level design specs to simple ETL coding and mapping standards.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Developed ETL's for masking the data when made available for the Offshore Dev. Team.
• Developed UNIX scripts for dynamic generation of Parameter Files& for FTP/SFTP transmission.
• Developed functions and stored procedures to aid complex mappings.
• Coded Teradata BTEQ scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Worked with team to convert Trillium process into Informatica IDQ objects.
• Extensively used the DQ transformations like Address validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Extensively worked on UNIX shell scripts for server Health Check monitoring such as Repository Backup, CPU/Disk space utilization, Informatica Server monitoring, UNIX file system maintenance/cleanup and scripts using Informatica Command line utilities.
• Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality.
• Worked on Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Coded Teradata BTEQ SQL scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Experience in creation of ETL Mappings and Transformations using Informatica PowerCenter to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters and Joiners.
• Responsible in preparing Logical as well as Physical data models and document the same.
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica IDQ cleanse Adapters.
• Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
• Scheduled Informatica workflows using OBIEE.
• Involved in implementing change data capture (CDC) and Type I, II, III slowly changing Dimensions.

Environment: Informatica PowerCenter 10.x/9.6, Informatica Data Quality (IDQ) 9.6, Oracle 11g, Teradata, PL SQL, SQL developer, TOAD, Putty, UNIX.

Senior ETL Informatica Developer

Confidential, Boston, MA

Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created mapping documents to outline data flow from sources to targets.
• Worked on Business support request (BSR) raised by business users for critical/high priority issues.
• Used SSIS to design ETL process using control flows and data flows.
• Using Data flows in SSIS, extracted data from an external data sources, flow that data through several transformations such as sorting, filtering, merging it with other data and converting data types, and finally store the result at a destination, usually a table in the data warehouse.
• Involved in creation of HLD and LLD document based on BR/FR and got those reviewed by customers along with detailed project timelines.
• Involved in building the ETL architecture using Informatica 9.6.1/ 9.5.1 and Source to Target mapping to load data into Data warehouse.
• Providing periodic update to customer on the coding, unit testing release and act as Coordinator between development and business team Knowledge of TABLEAU.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Performed Proof of Concept for Informatica Data Quality (IDQ).
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked on loading Flat Files into Data warehouse.
• Created stored procedures, collections and packages.
• Experience on Teradata utilities like Bteq, multi load, fast load and fast export.

Environment: Informatica 9.6.1/9.5.1, Teradata, DB2, Oracle, Flat Files, UNIX, Windows, SQL Assistant.

Informatica ETL Developer

Confidential, Maryland Heights, MO

Responsibilities:

• Extracted data transformed and loaded into Oracle database according to the specifications.
• Experience in creating Tables, Procedures, Functions, Views and other database objects on Oracle DB.
• Experience in writing Complex Queries, Subqueries, Co-related subqueries, Dynamic SQL queries.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target Designer, Transformation Developer and Mapplet Designer and Mapping designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Union, Normalizer, Sequence Generator, Update Strategy, SQL Transformation, Stored Procedure, and Joiner.
• Created and ran workflows using Workflow Manager to load the data into the Target Database. Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets.
• Created reusable components in the shared folder as it reduces time and effort.
• Integrated and installed IDQ on Informatica power center server machine to cleanse data.
• Designed IDQ mappings which are used as Mapplets in Power center.
• Validate data in the reports using Business Objects and provide an update on business queries.
• Involved in each phase of Software Development Life Cycle such as design, build, test and deployment phase.
• Deployed the code to the Production that follows the migration checklist.
• Used debugger to test the data flow between the source and target and to fix the invalid mappings.
• Migrated mappings and workflows from the development server to the Test Server to perform the unit, integration and system testing.
• Involved in all the existing releases and helped the team in resolving critical issues.

Environment: Informatica Power Center 8.6.1/8.1, Oracle 10g, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
• Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.
• Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on target table.
• Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings.
• Created mapplets and reusable transformations.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

Environment: Informatica Power Center 8.x, Repository Manager, Designer, Oracle 8i, SQL, UNIX, Win 2000/NT.

Informatica Developer

Confidential

Responsibilities:

• Analyzed various schemas for implementation and modeled the Data Warehousing Data marts using Star Schema.
• Created workflows and Worklets for designed mappings.
• Developed mappings and loaded data into relational database. Worked on Dimension as well as Fact tables.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Created mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data from flat files and oracle database, applied business logic to load them into the central oracle database.
• Created and monitored Sessions and Batches using Server Manager.
• Used various performance tuning techniques to improve the session performance (Partitioning etc).
• Successfully moved the Sessions and Batches from the development to production environment.
• Generated completion messages and status reports using Workflow manager.
• Extensively used PL/SQL procedures and functions to build business rules.

Environment: Informatica Power Center 7.1.4, Oracle9i, MS Office Visio 2003, Tableau 8.1, SQL

Informatica Developer

Confidential

Responsibilities:

• Designed and developed several complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Involved in design and development of Business Requirements in liaison to business users and Technical teams.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data from Database sources like Oracle, SQL Server, DB2 & flat files.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Created tables and partitions in database Oracle.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 7.1, Oracle 11g, SQL Server 2008, Flat Files, Windows 7, LINUX.