SUMMARY

• 8 years of Technical and Functional experience in Data warehouse implementations using ETL tools LikeTalend Informatica Power Center 9.x/8.x, Oracle 11g/10g, MS SQL SERVER 2012/2008.
• Extensive experience in Informatica Power Center in all phases of Analysis,Design,Development,Implementation and support of datawarehousing applications.
• Extensive knowledge of Data Modeling / Architecture, Database Administration withspecialization in Various ETL Platforms (Talend, Informatica)
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Strong knowledge in Data warehousing concepts, dimensional modeling Star Schema and Snowflakes Schema, Fact and Dimensional tables.
• Extensively worked on Transformations such as Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Extensive experience in designing and developing complex mappings from varied transformation logic and used over 100+ Components in designing Jobs inTalend
• Knowledge of SCD type 1 and 2 and implementation UsingTalend
• Experience in documenting High Level and Low level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.
• Experience with industry standard methodologies like waterfall, Agile within the software development life cycle.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Worked on flatfiles both of delimited and fixed length.
• Implemented different Slowly changing dimensions(SCD) using Informatica.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non - Reusable Tasks (Decision,Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Quick learner,excellent team player Possess good interpersonal, presentation and development skills with strong analytical and problem solving approach.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience inMicrosoft Visula C#in script component of SSIS.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Definingdata warehouse(star and snow flake schema), fact table, cubes, dimensions, measures usingSQL Server Analysis Services.
• Worked with report manager for deploying the reports across all the environments.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x (PowerCenter Repository, Informatica Designer, Workflow manager, Workflow monitor), Power Exchange, Developer (IDQ) and Analyst (IDE), Informatica Cloud, Informatica B2B DX / DT, Informatica MFT .

BI & Reporting: Business Objects Xi R3, Crystal Reports, SSRS,SSIS.

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

Databases: Oracle 11g/10g/9i, MS SQL Server 2012/2008, Teradata V2R6/V2R5, MS access,DB2.

Job Scheduling & other tools: PL/SQL Developer, Toad, Teradata SQL assistant 7.1, Control-M,Autosys,ILM 6.1,6.2.

Environment s: UNIX (Sun Solaris, AIX), Windows 2000/NT/XP/VISTA/7,8 Windows server 2008, Windows NT.

Languages: PL/SQL, SQL, XML, HTML, Data Structures, UNIX Shell Script.

Office Applications: MS Office 2003/ 2007/2013 ,Google Analytics, Adobe Analytics.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Understood the Business requirements based on Functional specification to design the ETL methodology in technical specifications
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured Flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used Filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented Complex Business Rules in Informatica Power Center by creating Re-usable transformations, and Robust Mapplets.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitionsfor the project which involved around 33 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various
• applications to the database and written functions, stored procedures and
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB

Confidential, Chicago,IL

Informatica Developer

Responsibilities:

• Involved in the entire SDLC process that includes Implementation, Testing, Deployment and Maintenance.
• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for Project Coordination.
• Involved in installing and maintaining MS SQL Server 2000/2005.
• Created Data Model or the Marketing Information System Team using Erwin.
• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS)andproduced ad-hoc, standard and create super user reports using(SSRS).
• Using SSAS created OLAPcubes for data mining and created reports from OLAP cubes using SSRS.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP)environment for accessing and translating data into understandable and usable business information using SSAS.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Using reporting services (SSRS) generated various reports.

ENVINORMENT:Windows XP, Windows 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.

Confidential

Informatica developer

Responsibilities:

• Worked on handling large amount of data usually in millions per day.
• Handled live data which usually come in millions depending on number of customers.
• Designed a system which accepts the requests based on certain flags and created a extract for handling such requests.
• Stored the customers data in a dimension table and a fact table will be incrementally loaded.
• Worked with dynamic sql transformation which involves lot of joins on fact and dimension tables.
• Used pre sql of source qualifier which involves handling many sql queries.
• Worked on Mapping and workflow variables and also how to use the mapping variables in workflow and viceversa.
• Used lot of functions like set variable function in order to assign the incoming values to mapping variables.
• Created mappings in such a way where we connect all the mappings using mapping and workflow variables which are part of a single workflow.
• Used pre session success varable assignment and also post session success variable assignment at non reusable session task in order to pass the workflow varibales to mapping and vice versa.
• Created Unix scripts in order to schedule or unschedule the workflows based on requirement.
• Created concurrent workflow which will be called form a different workflow using command task.
• Worked on continuous scheduling of informatica workflow.
• Used decision task, assignment task, email task based on requirement.
• Created parameter files at workflow level and also merged both of the parameter files used at workflow and session level.
• Created unit test cases and also documented all of them
• Used lookup transformation where I wrote a lookup override in order to divide the comma separated values into multiple rows by using CONNECT clause in oracle.
• Used oracle minus queries in order to compare the data between two schemas.
• Create a mapplet which can be reused across two mappings and functions to give a different output based on incoming data.
• Used transactional control transformation in order to generate dynamic files at mapping level.
• Used an approach to calculate the dynamic files by dividing with timestamp at session level.
• Worked on performance tuning where we increase the throughput by switching from Sql transformation and using the same query in source qualifier.
• Used parallel hint clause for increasing performance which divides across 16 CPU’s to run a oracle query which has multiple joins.
• Worked on informatica dynamic partitions which can be used for loading large amount of history data.
• Worked on calling the same workflow multiple times until a condition is satisfied which is handled in Unix script.
• Involved in code migration from development to integration testing, Staging and finally to Production Environment.
• Prepared documentation required to migrate all the objects across different environments.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, UNIX Shell Scripts

Confidential

Informatica Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document.
• Implemented Dimension model (logical and physical modeling) in the existing architecture.
• Worked with active transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Designed and developed Complex Mappings from various transformations like Unconnected and Connected lookup’s Expression, Sequence generator and more.
• Implemented Slowly Changing Dimensions According to the requirements.
• Used Workflow manager for creating, testing and running sessions and batches.
• Extracted data from DB2 and Oracle source systems and loaded into Flat files using Informatica.
• Designed incremental loading process to load data into Staging tables.
• Optimized existing applications at the Mapping level, Session level and Target level for better performance.
• Implemented reports like Drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Configured the sessions using Workflow manager to have multiple partitions on source data and to improve performance.
• Identified and removed bottlenecks in order to improve performance of mappings and workflows.
• Developed shell scripts for Informatica pre-session, post-session scripts
• Developed test plans and test scripts to test the data based on the business requirements.
• Responsible for regression testing ETL jobs before test to production migration.

Environment: Informatica Power Center 9.x/8.x, Business Objects 6.5, Oracle 10g/9i

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts to analyze the business requirements and created informative requirement document.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL Coding and Mapping standards.
• 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.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (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.
• 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.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• 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 and Type-2 mappings to update Slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from Flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center9.x/8.x/7.x, Oracle 10g, TOAD, PL/SQL, UNIX, Windows NT.