PROFESSIONAL SUMMARY:

• 9 plus years of experience in IT industry with special emphasis on design and development of database, data warehousing applications with good domain knowledge of Financial, Manufacturing, Communications and Insurance.
• Around 9 years of experience in Informatica PowerCenter 9.x/8.x/7. x.
• 9 plus years of experience in using different types of RDBMS databases like Oracle, SQL Server, Tera Data, DB2, Sybase, etc.
• 3 plus years of experience of real - time CDC (change data capture) design, development and implementation using Informatica PowerExchange 9.x/8. x.
• Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization and facts and dimension.
• Involved in the design of Multi-Dimensional Data Modeling (Star, Snow Flake schema) using Erwin 7.1/4.5 and MS Visio.
• Proficiency in data warehousing techniques for Staging area design, data cleansing, error handling, audit login, surrogate key assignment and real-time change data capture (CDC).
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Experience in integration of various data sources like Oracle, DB2, Flat Files, MQ series and XML Files into ODS.
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions).
• Expertise in SQL and PL/SQL programming and in-depth Knowledge of Views, Analytical Functions, Stored Procedures, Functions, Triggers.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder.
• Experience in using the Informatica command line utilities like pmcmd, pmrep server and pmrep agent to execute or control sessions, tasks and workflows in non-windows environments.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.x/8.x, Informatica PowerExchange 9.x/8.x, Informatica Data Quality 9.x/8.x

Data Modeling: Erwin 7.2/4.5, MS Visio

Programming Languages: C, C++, SQL, PL SQL, UNIX Shell Scripting

Reporting: OBIEE 11g/10g, BOXI

DB Tools: TOAD, SQL Navigator, SQL LOADER, SQL Management Studio.

RDBMS: Oracle 11g/10g, Teradata 13/12/V2R5, SQL Server 2008/2000, DB2, DB2 BLU, Sybase.

GUI: Visual Basic 6.0/5.0.

Scheduling: AutoSys, ESP, Control-M, FACETS 4.4, Salesforce

Operating System: Windows XP/ 7, UNIX (Solaris 8.0/10.0)

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr./Lead Informatica Developer

Responsibilities:

• Worked closely with the business and development teams to make sure that business requirements are correctly translated into database schemas and ultimately into the application.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Created mappings, which involved transformations, like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expression and Aggregator transformations to load the transactions, accounts and customer’s data from flat files. And used debugger to test the mappings and fixed the bugs.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions.
• Involved in the design, development and implementation of the Fact less Fact tables and related Dimensions.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Created and used reusable Mapplets and Worklets to reduce the redundancy.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle.
• Implemented Automations for Orders Fall Out for Reporting Team to Generate Reports every Hour.
• Monitor the ETL process job and validate the data loaded in DW.
• Created shell scripts in UNIX to automate the batch jobs.
• Used PMCMD to schedule jobs and shell scripting to upload data files into tables of the Oracle database.
• Analyzed the session and error logs for troubleshooting mappings and sessions.
• Used features like Email notifications, Scripts and Event-Wait for ETL process using Informatica PowerCenter.
• Performed unit test, integration test and performance test per the approved test cases, and documented test results for data migration.
• Provided data loading, monitoring, and system support and worked on data issues raised by end user during its production.
• Worked as coordinator between offshore and onsite.
• Helped Production Support Team to optimize existing mappings.

Environment: Informatica PowerCenter 9.6.1, Oracle Exadata, OBIEE 11g, DAC Scheduler, Putty, SCM, Rally, IDQ 9.6.1

Confidential, West Des Moines, IA

Sr. / Lead Informatica/ETL Developer

Responsibilities:

• Involved in the design, development and implementation of the Atomic Data Warehousing (ADW) process and Data Marts and facts and dimension.
• Extract, Transform and Load (ETL) analysis, design and development.
• Code Review and Documentation Review before going in to UAT.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Data Cleansing, Masking, Validation in the Landing/Staging Area.
• Part of Production Support Team and Monitored systems and processes to ensure seamless loading of data in time.
• Part of Retro prospective and Demoing different project in a sprint review.
• Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Extracting and transforming data from various relational databases, xml or flat files to the data warehouse.
• Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirement.
• Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data.
• Automated ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Used Informatica PowerCenter 9.5.1 for migrating data from various OLTP servers/databases to the data mart.
• Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed shell scripts for ETL jobs, Cleanup and Archive process for the entire Group subject area.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data for both Unit testing and UAT testing.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues, Heat-tickets in a prescribed time.
• Discussed with customers and technical support on Data Migration and Data warehousing.
• Developed standards and procedures to support quality development and testing of data warehouse processes.

Environment: Informatica PowerCenter 9.5.1, Informatica PowerExchange 9.5.1, IDQ 9.5.1, DB2, DB2 Mainframe, Teradata 14, SQL Server 2008/2014, UNIX Shell Scripts, Sun Solaris 10.0, Erwin 7.1, Windows 7, Control M.

Confidential, Chandler, AZ

Sr. / Lead Informatica/ETL Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.
• Gathered requirement and coordinated with various department to assure satisfactory and quality data content.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Designed star and snowflakes schemas and ETL Processes.
• Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Extracting and transforming data from various relational databases to the data warehouse.
• Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirement.
• Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data.
• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata warehouse database.
• Performing ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Used Informatica PowerCenter 9.0.1 for migrating data from various OLTP servers/databases to the data mart.
• Developed UTC SQL and Oracle PL/SQL Procedures, Functions and Packages to implement the business logic.
• Database logical Modeling and physical design multiple schema creation and maintenance on multiple platforms and also supported for the application development team.
• Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed shell scripts for ETL jobs, Cleanup and Archive process for the entire Group subject area.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
• Performed Unit Test for Informatica mappings and workflows in both development and test environments.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues, Heat-tickets.
• Developed data transformation processes, maintain and update loading processes.
• Discussed with customers and technical support on Data Migration and Data warehousing.
• Monitored systems and processes to ensure seamless loading of data in time.
• Developed standards and procedures to support quality development and testing of data warehouse processes.

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.5, IDQ 8.6.1, Oracle Exadata, PL/SQL, UNIX Shell Scripts, Sun Solaris 9.0, Erwin 7.1, Windows XP, Control M, Teradata 13

Confidential, Minneapolis, MN

Informatica/ETL Consultant

Responsibilities:

• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Extracted data from Flat files, SQL Server and Oracle and loaded them into Teradata.
• Involved in Data Profiling & Data Analysis on heterogeneous Database sources like Oracle, flat files.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Used the Integration service in PowerCenter 8.6 to start multiple instances of the same workflow.
• Developed Complex Reports using data providers, Union and Master/Detail, cross tab, Charts.
• Empowered end-users using Crystal reports by providing on-report sorting, reformatting and parameters made more interactive with the reports.
• Used Broadcast Agent Publisher for Report bursting, so that each individual receives particular information in Excel format and Created WebI reports and deployed them through Info View.
• Extensively used Calculations, Variables, and Sorted inputs, drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ, MLOAD and TPUMP scripts.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export and Fast Load.
• Created triggers to implement complex business process and supported the user interface with Stored Procedures to get the reports using SQL.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on Autosys Scheduler to automate the Workflows.
• Extensively worked on Folder Migrations and Code Migrations.
• Planned and executed Business Objects deployment for End-users and involved in documenting the project.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica PowerCenter 8.6.1/8.1.1 , Business Objects XIR2, SQL Server 2008, IDQ 8.6.1, Oracle 11g/10g, DB2, PL/SQL, TOAD, Putty, Autosys Scheduler, UNIX, Windows 2003 Server, Teradata 12

Confidential, Jersey City, NJ

Informatica/ETL Developer

Responsibilities:

• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Responsible for developing the mappings from given technical documents using various transformations like Aggregator, sorter, update, expression, etc.
• Experience in modifying changes to the existing mappings according to user requirements.
• Worked with sources like flat files, oracle and DB2 tables and Target database is oracle.
• Wrote various types of SQL queries involving joins, aggregate calculations and tuning the queries to optimize performance.
• Performed extensive testing and wrote queries in SQL to ensure loading of the data.
• Performed unit testing at various levels of the ETL and documented the results.
• Set Standards for naming conventions and best practices for Informatica map ping development and migration of mappings to QA and Production.
• Created Session, Event, command, and Control Decision and Email tasks in Workflow Manager.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extensively used Expression, Joiner for heterogeneous sources, lookup, filter, aggregate, and update strategy transformations to transform data before loading into the target tables.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Responsible for implementation of one-time data movement and data replication methods.
• Prepared migration checklist, fixed the errors, documented the changes applied and test results.
• Setting up batches and sessions to schedule the loads at required frequency using PowerCenter Workflow manager and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
• Developed and implemented the UNIX shell scripts for the start and stop procedures of the sessions.
• Used UNIX shell scripts to run the batches too.
• Used Agile software development methodologies based on iterations which allowed the project to adapt the changes quickly.

Environment: Informatica PowerCenter 8.1, Oracle 10g, DB2 OS/390 8.1.5, SQL Plus, PL/SQL, Microsoft Sql Server 2005, UNIX, Agile framework, Windows XP.

Confidential

Informatica/ETL Developer

Responsibilities:

• Developed and Tested Mappings and Workflows as per mapping specification.
• Experienced in performing the analysis, design, and programming of ETL processes for Teradata.
• Extensively worked in the Performance Tuning of the ETL mappings and workflows.
• Involved in writing shell scripts and added these shell scripts in Autosys as scheduled daily, weekly, monthly.
• Extensively created mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy, etc.
• Strong expertise in using both Connected and Un-Connected Lookup transformations.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Developed Re-Usable Transformations, Mapplets and Worklets.
• Used Informatica scheduler to run workflows on UNIX box and monitored the results.

Environment: Informatica PowerCenter 8.1, Oracle 10g, TOAD, UNIX, Windows XP, Linux, Harvest

Confidential

Informatica/ETL Developer

Responsibilities:

• Extracted data from different sources by using Informatica.
• Extensively used Informatica client tools as Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer and Transformations.
• Worked on different Vendors address, extracted and transformed data with business rules and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse and validate the data.
• Designed and Developed Complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Analyzed, Designed, Constructed and Implemented the ETL jobs using Informatica.
• Created Users, User groups and Database Connections. Managed User privileges using supervisor.
• Created universe and reports.

Environment: Informatica PowerCenter 8.1, Business Objects 6.5, Windows NT, PL/SQL, Excel, SQL Server 2000, Oracle 10g and Linux.