SUMMARY

• Over 9 years of extensive experience in Information Technology with special emphasis on Analysis, Design and Development of Database/Data Warehousing/Client - Server applications.
• Experience in all the phases of Data warehouse life cycle involving design, development, and analysis, debugging &testing using ETL, Data Modeling and reporting tools.
• Strong experience in building Data Marts using Star Schema and Snowflake Schema dimensional methodologies using both Ralph Kimball’s and Bill Inman’s approaches.
• Solid Data warehousing ETL experience using Informatica 10.x/9.x/8.x under many database environments like Oracle, SQL Server and DB2.
• Extracted and transformed, structured and semi structured data from various sources such as Relational Sources (Oracle, SQL Server, DB2, and MS Access) and Files (flat files, .csv, COBOL, and XML).
• Used CDC (Change Data Capture) methods to extract the data from sources, as well as loaded the data into the target systems to support CDC for downstream applications.
• Knowledge in Designing Intelligence reports using Business Objects, IBM Cognos, and Tableau.
• Solid experience in implementing data loading strategies/methods on various databases to populate Dimensions and Fact tables for Data warehouses.
• Experience in implementing SCD’s (Slowly Changing Dimensions) to maintain the history of dimension data for various analytical and reporting needs.
• Implemented performance tuning at Source, Target, Mapping, Session, and System levels
• Hands-On SQL experience in working with SQL queries, PL/SQL Procedures/Functions, Table Partitions, Packages, to load data into Data Warehouse/Data Marts.
• Workable knowledge in using informatica IDQ tool.
• Strong experience in SDLC Methodologies - Waterfall and Agile.
• Expertise in writing Unix Shell Scripts using kash and bash.
• Experience in creating migration plans, process flows and dependency diagrams and scheduling the jobs accordingly using various scheduler like Tivoli Work Scheduler, CA7, AutoSys and CronTab.
• Proficient in handling production incidents (critical issues) and production related issues involving multiple application stakeholders.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• InteractedwithCustomersforrequirement gathering,effectiveanalysisand to provideend-user training.
• Experienced in developing Dashboards Reports inCognos 10.
• Strong writing and documentation skills and Excellent track record as individual and team player with effective communication skills.

TECHNICAL SKILLS

Operating system: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS.

ETL Tools: Informatica Power Center 10.x/9.x/8. x.

Data Modeling: Erwin 4.0/3.x, Visio 2000.

BI Tools: Business Objects XI, OBIEE, Erwin, IBM Cognos Business Intelligence 10. x, Tableau.

RDMS: Oracle 11g/10g/9i, db2 universal database 8.1/7.1, SQL Server 2008/2008 R2/2012, Teradata, Sybase.

GUI: SQL developer, TOAD, AginityWorkbench.

Testing Tools: HP Quality center, Load Runner, Win Runner.

Languages: Pl/SQL, T-SQL, HTML, XML, UNIX, JAVA and C

PROFESSIONAL EXPERIENCE

Confidential, Middlebury, CT

Informatica Developer

Responsibilities:

• Assisted in building the ETL source to target specification documents by understanding the business requirements
• Extracted data from various sources like COBOL Files, Flat files (delimited & fixed width), Oracle to maintain consistency and performed validation.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, normalize, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations and update strategy.
• Created Complex Mappings which involved Slowly Changing Dimensions to implement Business Logic and capturing the deleted records in the source systems.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Created Connected and Unconnected Lookup Transformation to look up the data from the source and target tables.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Extensively used the Workflow Manager Tasks (Session, Command, Decision, Event Wait, Event Raise, Control, Email and Timer) for creating complex data process flows for loading the data into the Data mart tables.
• Extensively used Mapping/Workflow Parameters & Mapping Variables in Informatica mappings and workflows.
• Created the generalized processes using the Parameter files for running the workflows on different sets of data from the source.
• Used SQL Loader for extracting the data from Flat Files into Oracle.
• Used the Debugger for validating and troubleshooting the mappings and provided the production support to release the data on committed timeline.
• Monitored and Tuned the Workflows for best performance by changing the block sizes, data cache sizes, Sequential Buffer lengths and Target commit counts.
• Tuned the mappings by using sorted data, changing the Aggregator Caches, and re-using lookup caches.
• Used PMCMD extensively to start, stop, schedule, and monitor informatica workflows.
• Migrating all the UNIX shell scripts and Parameter files via Tivoli Workload Scheduler to various Environments.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Precise Documentation was done for all mappings and workflows.
• Generated variousList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill- DownandDrill-Through Reports.
• Created Dashboards to present criticalcompany data in a single report withpie charts andMulti promptsinReport Studio.
• Experience in creating complex reporting - complex Drill Through, discontinuous Cross Tab, Summary reports, Burst reports.
• Developed various reports using functionalities likeRender Variables,Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Gathered and analyzed business requirementsfrom users and business community.

Environment: Oracle 11/g, Informatica Power Center 9.5, Ibm cognos 10.1,Unix, Mainframe, Toad, F-secure SSH2, MS-Access, Business Objects 5.1, Flat Files, COBOL, Sun Solaris, SQL, PL/SQL and SQL Loader, Windows 7, Tivoli Scheduler.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Used ETL process to load data from Oracle and Flat Files to the Data Warehouse.
• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Populated the Staging tables from various Sources like Flat files (Fixed Width and Delimited), Relational Tables (SQL Server, and Oracle).
• Imported XML Source files to Designer, modified groups, used in the Mappings and loaded into Target.
• Field level validations like Data Cleansing and Data Scrubbing were applied on various Data Sources.
• Analyzed Source System data and used Informatica Power Center designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Created Mappings using Transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Used pre-defined workflow variables and created persistent workflow variables to reference values and record information in a workflow.
• Created Type II Slowing Changing Dimensions using Lookup Transformations and Update Strategy Transformations.
• Used Debugger to validate mappings and to obtain troubleshooting information about data by utilizing Breakpoints.
• Created stored procedures to remove indexes prior to load data and recreated the indexes after the loading task has accomplished.
• Created and Executed Sessions, Sequential and Concurrent Batches for proper execution of mappings using Workflow Manager.
• Used Informatica Workflow Manager for Creating and executing the sessions by scheduling or running them on demand.
• Involved in writing shells scripts and automate the sessions running processes using Crontab.
• Developed data profiling, data mapping, data validation, data manipulation using Informatica Data Quality (IDQ) to maintain data quality.
• Created Informatica mappings and mapplets using Informatica Data Quality (IDQ) tool.
• Used Informatica Data quality (IDQ) tool where address validator transformation (address doctor) to validate incoming address.
• Created quality rules, development and implementation patterns with cleanse, parse, standardization, validation, scorecard transformations.
• Used PMCMD, PMREP commands for running the workflows from command prompt.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Performance Tuned Informatica session for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables
• Worked closely with DBA in tuning SQL queries.

Environment: Informatica Power Center 9.1, IDQ 9.1, Oracle10g, SQL Loader, PL/SQL, MS SQL Server 2008, XML files, Unix, Windows 7, TOAD, Erwin.

Confidential

Informatica Developer

Responsibilities:

• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a company-wide-ETL Solution using Informatica.
• Worked with filter transformations and flat files to identify source and target bottlenecks
• Worked with various transformations like source qualifier, router, update strategy, expression transformation, lookup transformation, sequence generator, joiner, rank, aggregator transformation and sorter transformation.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Fast Export utility to extract large volume of data and send files to downstream applications.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created stored procedures/functionsand wroteSQL scriptsfor implementing the business logic to load data into tables.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partition and data/index cache to manage very large volume of data.
• Created shell scripts for file validations and automation of the jobs
• Migrated code to production and Responsible for managing the test and production environment.
• Supported daily production by monitoring, troubleshooting and fixing the failed jobs
• Monitored the execution of production jobs and execution logs.

Environment: Informatica Power Center 9.1, Oracle 10g, Informix, Autosys, Windows XP, SQL, PL/SQL,Unix.

Confidential

Informatica Developer

Responsibilities:

• Developed, supported and maintained ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Created Common objects for the ETL team to maintain the Common Code.
• Designed new database tables to meet business information needs.
• Used lookup transformation, Aggregator transformation, Filter transformation, Update strategy and Router transformations.
• Developed complex mappings to use heterogeneous sources like Oracle, Sybase, SQL Server and Flat Files to perform extract, transform and load data into the Warehouse Oracle Database.
• Staging table mappings has been created to hold the data from the source based on the CDC logic (Change Data Capture) and then transforms the data into appropriate Dimension tables.
• Designed complex mappings to implement SCD type 1 SCD type 2 dimension.
• Created reusable Tasks, Sessions, reusable Worklets and workflows in Workflow manager.
• Performed tuning on transformations and mappings for better performance.
• Monitored the sessions that are running, scheduled, completed and failed.
• Debugged the mappings when the session failed.
• Used shell scripting for file manipulations, ftp and scheduling Informatica workflows.
• Created SQL queries extensively worked on Views, Stored Procedures and Triggers.
• Worked with Informatica administrators to set up project folders in development, testing and Production.
• Involved in code review meetings.

Environment: Informatica 8.x, Linux, bash, Oracle 9i/10g, Sybase, DB2, SQL Server, Flat files, SQL, PL/SQL

Confidential

Informatica Developer

Responsibilities:

• Developed, supported and maintained ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Created Common objects for the ETL team to maintain the Common Code.
• Designed new database tables to meet business information needs.
• Developed complex mappings to use heterogeneous sources like Oracle, Teradata and Flat Files to perform extract, transform and load data into the Warehouse Oracle Database.
• Created mappings on source data files, applied transformations on the data using Filter, UpdateStrategy, Aggregator,Expression, JoinerTransformations andloadedinto data warehouse.
• Used Slowly Changing dimension type2 methodology for accessing the full history ofaccounts and transaction information.
• Performed tuning on transformations and mappings for better performance.
• Monitored the sessions that are running, scheduled, completed and failed.
• Debugged the mappings when the session failed.
• Used shell scripting for file manipulations, ftp and scheduling Informatica workflows.
• Created SQL queries and extensively worked on Views, Stored Procedures and Triggers.
• Migrated mappings from Development to Testing to Production.
• Involved in code review meetings.

Environment: Informatica8.x, Oracle 9i, PL/SQL, TOAD, Windows.