PROFESSIONAL SUMMARY:

• Over 7+ years of overall experience in IT Industry with Data Warehousing, OLAP reporting tools, ETL tools using industry accepted methodologies and procedures.
• Expert knowledge in working with Informatica Power Center 9.x/8.x/7.x (Designer, Repository Manager, Repository Server Administrator Console, Server Manager, Workflow Manager, Workflow Monitor) and Knowledge of Informatica 7.x/8.x/9.x in Installation and Setup.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Enterprise Data Vault, SCD, Surrogate keys, Normalization/De Normalization.
• Experience in Integration of various data sources with Relational Databases like Oracle, SQL Server and Worked on integrating data from Flat Files.
• Experience in profiling data using Informatica Data Quality 9.5.0 (Analyst Tool).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Mapping Designer, Transformation Developer, Mapplet Designer, Schedulers and Warehouse Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable Transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver 9.1).
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services 2005 (SSIS) and Informatica Power Center tool. 
• Extensive experience in error handling and problem fixing in Informatica.
• Designed Complex Mappings and expertise in Performance Tuning.
• Experience in troubleshooting by tuning Mappings, identify and resolve performance bottlenecks in various levels like Source, Target, Mappings, and Session.
• Involved in Implementing Slowly Changing Dimensions, Star Join Schema Modeling, Snowflake Modeling, FACT tables, Dimension tables, Demoralization.
• Proficient in using Informatica Workflow Manager, Workflow Monitor, pmcmd (Informatica Command line utility) to Create, Schedule and Control Workflows, Tasks, and Sessions. Experience in Oracle9i/10g/11g, SQL Server, Teradata, and DB2 etc.
• Sound knowledge of test management tool HP Quality Center, HP Application Lifecycle Management and Rational Clear Quest tools.
• Extensive Experience in UNIX (AIX/Solaris/ HP-UX 11.x), and Windows Operating system.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, and Packages.
• Used Change Data Capture to capture changes in database, used these variables in Informatica Mappings.

TECHNICAL SKILLS:

OS: UNIX

Languages: SQL, PL/SQL, C, C++,

ETL Tools: Informatica Powercenter 7.X, 8.6, 9.1,9.5

Scripting Languages: Unix Shell scripting, VBA Scripting

Database: Oracle 8i/9i/10g/11g, Teradata, SQL server,Db2,Sybase.

Database Tools: TOAD, Teradata

Loaders: SQL loader, Fastload, TPT, Multiload

Scheduling Tools: Control-M,Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. ETL Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis to develop Sensitive Data Analysis report.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used features such as Policies, Profiling, creating Plans on Informatica TDM tool.
• Used these Plans to create Workflows according to the specifications and development parameters.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Used SQL tools like management studio to run SQL queries and validate the data.
• Used SQL tools like Rapid Sql and Sql developer to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.

Environment: Informatica Power Center 9.6.1, TDM 9.5.1, Rapid Sql, SQL SERVER 2012,Oracle 11g, XML, T-SQL, Batch Scripts, Rational Suite, Perforce,Sybase v6.0,Oracle Plsql,Unix Shell Scripting,

Confidential, Allen, Texas

Sr. ETL Informatica Developer

Responsibilities:

• Involved in the source data landing process, wrote scripts to load various source files like txt, csv, delimited and oracle dump files.
• Responsibilities included source system analysis, data transformation, and loading, validation for data marts and data warehouse.
• Worked closely with Business Analysts in requirements gathering (BRD) and source system analysis and translated the business requirements into technical specifications to build the Enterprise data warehouse. 
• Analyze and Estimation durations for milestone after understanding requirements from Business Analyst.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle. 
• Used Change Data Capture to capture changes in database, used these variables in Informatica Mappings.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements using mapping parameters and variables. 
• Used HP Quality Center and Rational clear quest as test management tools in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement. 
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives. Worked on generating the Interface files based on the business requirements.
• Teradata utitlities such as multi load,fast load,fast export and TPump to insert, update and upsert Data,extract and load Data.
• Extensively used ETL processes to load data from various source systems such as DB2, SQLServer and Flat Files, XML files into target system Teradata by applying business logic on transformation mapping for inserting and updating records when loaded.
• Upgrade from Informatica 9.1 to Informatica 9.5
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Control-M Jobs monitoring, job flow analysis and troubleshooting
• Maintaining (Create/Modify) Control M jobs and interfaces.
• Worked on ETL Coding,Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested in Data Stage.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Finding the Informatica mappings bottlenecks and optimizing the mappings to get the best performance and tuning the SQL queries as well.
• Implemented partitioning and bulk loads for loading large volume of data.

Environment: Informatica 9.5,Data Stage 9.1, DB2, Oracle, Teradata, Unix, Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer,ILM, DB2 UDB 9.5, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer),Data Stage 9.1, Oracle 11g/10g, control M,Terra Data,PL/SQL,Oracle Data Integretor, Toad, Perl, Unix Shell Scripting, XML and Flat Files.

Confidential, Bloomington, IL

Sr. ETL Informatica Designer

Responsibilities:

• Conducted JAD sessions with End user Meetings and Responsible for gathering Requirements
• Responsible for converting Functional Requirements into Technical Specifications
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, HL7 Files, flat files, XML files and loading into Staging and Enterprise Data Warehouse
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Involved in deploying applications in Informatica developer/DataStage.
• Worked on DataStage Designer, Manager, Administrator and Director.
• Designed and developed Mappings for loading MDM Hub
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java, XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Converted SQL Server SSIS Packages logic into Informatica mappings.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets for staging unstructured HL7 files into Data Vault
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Automated daily load reports to send messages to the concerned personal in case of process failures and discrepancies.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastloada and Bteq scripts while loading data into the target tables in Teradata Database.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in Oracle Data Integrator.
• Used ODI commands like ODI File Move, odiFileAppend, odiFilecopy.
• Extensively worked on batch scripts to automate workflows and to populate parameter files.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data into Data vault
• Used SQL tools like management studio to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Managed Control M scheduling on Production, Quality Assurance and Development databases.
• Updated FTP set up using Control M for Production.  updated FTP set up using Control-M for Production. 
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Involved in Test Data Management for Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 8.1/9.5.1, IDQ 9.1, Embarcadero, SQL SERVER 2008, XML, T-SQL, Oracle Data Integrator. Batch Scripts, control M, Rational Suite, BTEQ Scripts,Terra Data Utitlities,Business Objects XI R2,

Confidential, Sacramento, CA

ETL Informatica Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer.
• Analyze the raw data from alliance partners and perform coding to generate the reports according to the Data model.
• Working with the application users to understand their requirements, analyzing the requirement, documenting and getting sign off for the development team to start with the development effort.
• Responsible for determining the bottlenecks with Informatica Server and fixing the issues by cleaning the Informatica repository logs on timely basis.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Created various standard/reusable jobs in DataStage using various active and passive stages likeSort Lookup, Filter, Join, Transformer, aggregator, Change Capture Data, Sequential file, DataSets.
• Coordinate production change requests and production releases.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts, BTEQ Scripts and scheduling tools.
• Troubleshooting load failure issues and data quality issues on a day to day basis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Maintain documents for all the Development work done and error fixings performed.
• Involved in deploying and redesigning of several small ETL processes for the existing research line of business.
• Involved in developing reports using Business Objects.
• Used tools like TOAD and SQL navigator to run the queries and validate the data
• loaded into Marts and different other layers like Data Warehouse and Persistent Staging.
• Responsible to Run Unix scripts to startup the Java Web Service to generate the Load confirmation emails to users.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Teradata, UNIX (Sun Solaris5.8/AIX), Windows XP Professional. DataStage 8.7.

Confidential

Informatica Developer

Responsibilities:

• Gathered business requirements, established functional specifications, translated them to design specifications.
• Data conversions from different legacy systems in accordance with the business rules into the Oracle Application system.
• Worked closely with SME’s to convert the legacy data for assigned modules.
• Worked independently and in a team to convert Item Costs, Price Lists, Quantity On-Hand and Sourcing rules and Assignment sets from various systems into the Oracle EBS interface tables.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Written Complex SQL overrides for source qualifier and Lookups in mappings.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EBS.
• Written ETL specifications for all the development tasks, to better evolve the ETL design.
• Worked with various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Involved in Test Data Management with the testing team to build the test plans.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performance tuning to ensure optimal session performance.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Designed and created logical & physical data models to support strategic business decisions.
• Designed, Developed, Reengineered and fine-tuned SQL queries and Oracle Stored Procedures and triggers.
• Involved in Designing data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed Informatica mappings for data loads.

Environment: Informatica 8.5(Repository Manager, Repository Server Administration Console, Power Center Designer, Workflow Manager, Workflow Monitor), Power Analyzer 4.1, Erwin 4.0, COBOL, Oracle 10g, Teradata, PL/SQL, Autosys, Windows 2000, DB2, Windows NT 4.0

Confidential

ETL Informatica Developer

Responsibilities:

• Coordinated with the client and gathering the user requirements.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Worked on developing mappings and mapplets to extract and load the data from Oracle, Flat files and COBOL files.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Used Type 1 SCD (discard previous versions of dimensions in the target table) and Type 2 SCD (maintain history) mapping to update Slowly Changing Dimension Tables Scheduling the workflows comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Wrote complete PL/SQL procedures and SQL queries using Toad 7.6.
• Handled creation, modification and documentation of Packages, Procedures, Functions and Indexes.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Maintained warehouse metadata, naming standards and data warehouse standards for future application development
• Involved in different Team review meetings, Prepared project documentation, Program Specifications, Test Cases and Participated in the complete SDLC.

Environment: Informatica Power Center 7.1/6.4, Informatica Power Exchange, Toad 7.6,DB2 9.1, Autosys, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, Cobol, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting(putty).