SUMMARY

• Seven plus (7+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse, Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.x/ 8.6.1/8.5/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Data Warehousing ETL Tools: Informatica Power Center 9.6/9.5/8.x, Informatica Power Analyzer/ Powermart, Crystal Reports.

Operating System: Windows, UNIX, Linux, MAC IOS.

Databases: Oracle 12c/11g/10g/9i/8.0, MySQL, SQL Server 08//05, Teradata

Programming: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, C, JAVA, PHP, HTML, XML, JSON, JAVA SCRIPT.

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Erwin.

Reporting Tools: SSRS, SSAS, Cognos, SAP BO

Tools: TOAD, SQL Developer, SQL*Plus, MS Office, Microsoft Visio, SharePoint, Putty, WinScp

PROFESSIONAL EXPERIENCE

Confidential, WA

ETL Informatica Developer

Responsibilities:

• Involved and understanding the Business requirements/discuss with Business Analyst, analyzing the requirements and preparing business rules.
• Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, etc.
• ETL includes the selection criteria to extract data from source systems (Cloud), performing any necessary data transformations or derivations needed, data quality audits, and cleansing.
• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Datawarehouse.
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.
• Experienced in methodologies like SDLCand Agile methodologies such as SCRUM.
• Contributed and actively providing comments for user stories review meeting within an AGILE SCRUM environment.
• Extensively worked with transformations like Lookup, Expression, Router, Joiner, Update Strategy, Filter, and Aggregate.
• Extensively worked on SQL override in Source Qualifier Transformation for better performance.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.

Environment: Informatica PowerCenter 9.5/9.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Informatica Cloud, Power Mart, Cognos, SSRS, Oracle 11g, Teradata, SQL, PL/SQL, Unix, Erwin, Putty, Winscp, QC(Quality Center),Windows XP, Auotsys.

Confidential, Oakland, California.

ETL/Informatica Developer

Responsibilities:

• Worked with Informatica power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked extensively Informatica Transformation like Source Qualifier, Rank, Router, Filter, Joiner, Lookup, Aggregator, Union, and Sorter etc.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Analyzed Business requirements provided by Business Analysts for the code changes and provided feedback as per requirements.
• Created complex Aggregate, Expression, Join, Filter, Router, Lookup and Update transformation.
• Designed and created mappings, defined workflows, tasks, monitored sessions, exported and imported mappings and workflows, recovery and backups.
• Monitored and tracked the applications as per the schedule run Autosys.
• Designed for populate target tables for one time load and Incremental loads.
• Worked on extracting, transform and loading of data from flat file, sources to target using transformations in the mappings.
• Wrote shell scripts to load data into staging tables and then into Oracle base tables using SQL*Loader.
• Used performance tuning logic on Source, Targets, Mappings, Sessions to provide maximum effectiveness and performance
• Created a batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Completed documentation in relation to detailed work plan, mapping documents, high-level and low-level data models.

Environment: Informatica PowerCenter 9.5, Oracle 10g, SQL, PL/SQL,UNIX Shell Scripting, Oracle SQL developer, Windows XP/Vista

Confidential, Littleton, CO

ETL/ Informatica Developer

Responsibilities:

• Analyzed source and target systems for loading data into CDW and to create external data feeds.
• Involved all the phases of SDLC design and development.
• Involved in gap analysis and STM documentation to map flat file fields with relational table data in CDW.
• Developed mappings, mapplets, and reusable transformations to load external data into CDW.
• Extracted data from CDW to create delimited and fixed width flat file data feeds that go out to external sources.
• Analyzed Design documents and developed ETL requirement specs.
• Created re-usable objects and shortcuts for various commonly used flat file and relational sources.
• Developed a shell script in order to append Date and Time stamp for output xml files, to remove empty delta files and to FTP the output xml files to different servers.
• Validated Logical Data Models relationships and entities.
• Determined data linage by including all associated systems in data profile.
• Integrated data into CDW by sourcing it from different sources like Oracle, Flat Files and (DB2 and VSAM) using Power Exchange.
• Wrote & reviewed technical designs.
• Created UNIX scripts to deal with flat file data like merging delta files with whole files and to concatenate header, detailed and trailer parts of the files.
• Developed Mappings which loads the data into Teradata tables with SAP definitions as Sources.
• Created mappings to read parameterized data from tables to create parameter files.
• Used XML Source Qualifier and XML source definition to represents the data elements that the Informatica Server reads when it executes a session with XMLDeveloped.
• Used XML Parser transformation to extract XML data from messaging systems.
• Used ODI to perform data integration to ELT processing. Data was extracted from multiple sources, sent through several transformation processes and loaded into a final destination target.
• Used SAS for data entry, Retrieval, Management report writing and Statistical analysis.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load (ETL) data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Used Message broker as translate messages between the interfaces.

Environment: Informatica PowerCenter 9.1, Power Exchange, Windows, Oracle, Toad for Oracle, UNIX, workflow scheduler, Perl.

Confidential, New York City, New York.

ETL/Informatica Developer

Responsibilities:

• Analyzed source and target systems for loading data into CDW and to create external data feeds.
• Involved all the phases of SDLC design and development.
• Involved in gap analysis and STM documentation to map flat file fields with relational table data in CDW.
• Developed mappings, mapplets, and reusable transformations to load external data into CDW.
• Extracted data from CDW to create delimited and fixed width flat file data feeds that go out to external sources.
• Analyzed Design documents and developed ETL requirement specs.
• Created re-usable objects and shortcuts for various commonly used flat file and relational sources.
• Developed a shell script in order to append Date and Time stamp for output xml files, to remove empty delta files and to FTP the output xml files to different servers.
• Validate Logical Data Models relationships and entities, Determine data linage by including all associated systems in data profile.
• Excellent Data Profiling experience used Data Polling validating data patterns and formats.
• Developed Mappings, which loads the data in to Teradata tables with SAP definitions as Sources.
• Created mappings to read parameterized data from tables to create parameter files.
• Used SAS for data entry, Retrieval, Management report writing and Statistical analysis.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load (ETL) data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).

Environment: Informatica PowerCenter 9.1, Power Exchange, Windows, Oracle, Toad for Oracle, UNIX, workflow scheduler.

Confidential, Irvine, CA

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Worked on both kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources and transformed and loaded data into Data Warehouse Targets using Informatica.
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Worked extensively transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Used UNIX cron jobs to schedule the sessions to automate the update process in the workflow manager
• Worked with pmcmd to interact with Informatica Server from command mode and to execute the shells scripts.
• Worked with different sources such as Oracle, MS SQL Server and flat files.
• Worked extensively on slowly changing dimension tables and fact tables.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked on optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 8.6, Oracle 9i, Erwin, SQL, PL/SQL, Windows Server 2008, HP Quality Center, Unix, Putty, WinScp.