SUMMARY

• Around 7 years of IT experience in Design, Development and Implementation of Data Warehouse as an ETL Developer. Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica Power Center and Data Quality 9.x/8.x.
• Experience in Analysis, Design, Development, Testing of Data warehouses and Data marts. Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Worked on multiple Data warehousing projects with complete Software Development Life Cycle process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Analyzed, Designed and Implemented different stages of Data Warehouse.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, SQL*Plus, Oracle SQL Developer, XML files and Flat Files into staging area. Also experience in Optimizing Database querying, data manipulation using SQL and PL/SQL in Oracle, flat files and SQL Server databases.
• Experienced in using various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator etc. to load consistent data in to DB2, Oracle, SQL Server databases.
• Expertise in working with Informatica tools - Power Center Client tools - Designer, Repository Manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Stored Procedure transformations, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Strategy in Informatica Power Center Designer.
• Performed data profiling, data cleansing, data conversion, exception handling and data matching using Informatica IDQ.
• Highly proficient in writing, testing and implementation of Triggers, Stored Procedures, Functions, Packages, Cursors using PL/SQL.
• Experience in loading data, troubleshooting, Debugging mappings, tuning mappings etc.
• Experience in Audit, Balance checks and Error handling techniques.
• Good working experience on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Experience in writing UNIX shell scripts.
• Automation and scheduling of workflows to minimize manual intervention.
• Experience in providing post deployment warranty support and Production Support.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines. Self-starter with good interpersonal and communication skills.

TECHNICAL SKILLS:

Data Warehousing/ETL: Informatica Power Center 9.x/8.x using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor, IDQ 9.x (Developer Client, Model Repository Service (MRS), Data Integration Service (DIS), Analyst Service, Informatica Administrator, Address Validator), SQL*PLUS, SQL*Loader

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2012/2000, Sybase 12.x/11.x, Teradata

Reporting Tools: Cognos 10/8x, MS Access Reports, OBIEE 11g

Programming: SQL, PL/SQL, SQL*Plus 8.1.5, Unix Shell Scripting

Environment: HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Win 2000, Win XP

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, N.J

Informatica Developer

Responsibilities:

• Involved in various phases of project life cycle such as gathering requirements, development of the code and its implementation and testing.
• Reviewed the physical translations of business rules entered in metadata manager and have working sessions with the data warehouse team to clarify the entries.
• Development and testing of the business rules that are coded in Informatica ETL.
• Developed mappings using various transformations such as Source Qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup (Connected & Un-connected), Stored Procedure and expression as per the business requirement.
• Created reusable transformations.
• Created/modified various Informatica mappings and workflows for the successful migration of data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Designed, developed, implemented and maintained Informatica Power center and IDQ 9.5.1 application for matching and merging process.
• Developed a process in IDQ for cleansing and migrating global Customer data from flat files to Oracle 11g and IDQ code deploy to Power center client.
• Used Developer client, Analyst Service and Informatica Administrator to integrate, profile, cleanse, monitor and load data in IDQ.
• Extensively worked in the performance tuning of ETL mappings.
• Raised Non-production Request (NPR) to migrate code to higher environments. Also raised Change Request (CR) to migrate code to Prod environment.
• Used Tidal job scheduler application to schedule batch runs.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Coordinating with the team and interacting with the client for implementation of the deliverable.
• Responsible for Trouble shooting, Production support, Performance tuning and Batch monitoring activity.
• Analysis and debugging of issues.

Environment: Informatica Power Center 9.5.1, IDQ 9.5.1, Oracle 11g, SQL, T-SQL, SQL Server 2012, Tidal Enterprise Scheduler, OBIEE 11g, Windows 7

Confidential, Peapack, N.J

Informatica Developer

Responsibilities:

• Interacted with Business users to understand the Business requirements and prepared technical documents for implementing the solutions as per business needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Involved in logical and physical data modeling and analyzed and designed the ETL processes.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used Informatica client tools to extract data from different sources like flat files and oracle.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Created IDQ mappings with key generator, labeler, standardizer, match, consolidator, sorter, address validator transformations etc.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Created users, tables, triggers, stored procedures, joins and hash indexes in Teradata database.
• Performed performance tuning on Teradata Tables.
• Used push down optimization techniques with Teradata databases.
• Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.
• Creating solution documents for developed mappings.
• Involved in solving day-to-day problems, giving support to the users.
• Communicated issues and progress to project manager.

Environment: Informatica Power Center 9.5.1, IDQ 9.5.1, Oracle 11g/10g, Teradata, SQL, PL/SQL, TOAD 9.6, Windows XP

Confidential, Georgetown, KY

Informatica Developer

Responsibilities:

• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Involved in analysis, requirements gathering, designing functional/technical specifications, development, deploying and testing.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensive experience in full cycle implementation of Informatica.
• Involved Migration activities from development and pre-production environments.
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Worked on SQL tools like TOAD to run SQL queries and validated the data.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Transformation Developer.
• Performed scrubbing and cleaning of the data.
• Performed Unit Test and Integration Test for the ETL Processes.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, HP UNIX Shell Scripting, Informatica Power Centre 9.1.0, Sybase

Confidential, Palo Alto, CA

Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.
• Worked with Power Center- Designer tool in developing mappings and mapplets to extract and load the data from various sources.
• Developed various transformations for loading the data into target warehouse.
• Usage of Aggregator, SQL Overrides usage in Lookups and Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Developed various reusable transformations using the Transformation Developer in the Informatica Power Center Designer.
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Responsible for Debugging & Performance Tuning of the Informatica mappings and sessions.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Extensive use of SQL commandswithTOADenvironment to create Target tables.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2, TOAD, SQL Server 2005, T-SQL, SQL, Windows NT/XP

Confidential, Lynchburg, VA

Informatica Developer

Responsibilities:

• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Involved in leading onsite and offshore resources.
• Provided project estimations to client and upon agreement with client delivered project accordingly.
• The objective was to extract data from Flat Files and Oracle database and to initially load it into a single data warehouse repository, which was in Oracle.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Warehouse.
• Used different transformations in Informatica PowerCenter to develop Mappings.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Extensively used ETL to load data from wide range of sources such as flat files, XML files, Oracle and Sybase.
• Responsibilities included designing and developing complex Informatica mappings including Type-I slowly changing dimensions.
• Involved in writing shell scripts in UNIX for Informatica ETL tool to run the sessions.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Responsible for to provide production support and resolve issues.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, TOAD, UNIX shell scripting, SQL Server, Erwin

Confidential, Carbondale, Illinois

Informatica/Oracle Developer

Responsibilities:

• Involved in gathering requirements to understand the business requirements.
• Created Data Structures. I.e. Tables & views and applying the referential integrity using SQL.
• Responsible for creating and modifying the PL/SQL procedure, function, triggers according to the business requirement.
• Worked closely with users, decision makers to develop the transformation logic to be used in Informatica Power Center.
• Converted the business rules into technical specifications for ETL process for populating fact and dimension table of data warehouse.
• Created mappings, transformations using Designer, and created sessions using Server Manager.
• Created mappings with Slowly Changing Dimensions as the load was monthly load.
• Created staging tables to do validations against data before loading data into original fact and dimension tables.

Environment: Informatica Power Center 8.4, Oracle 9i/8i, SQL Server, UNIX, Windows NT

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for ETL extraction, Transformation and loading data from heterogeneous source systems to Staging area.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations, maintaining Informatica workflows.
• Created Worklets to run several sessions sequentially and Developed schedules to automate the updated process and Informatica Sessions/Worklets.
• Extensively worked on Performance Tuning and there by decreased the load time.
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads.
• Extensively worked with Lookup Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked on UNIX Shell scripts and invoked oracle procedures and Informatica workflows via shell scripts.
• Responsible for error handling using Session Logs, Reject Files and Workflow Logs in the Workflow Monitor.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Involved in all the testing phases of the project to check whether the data is being processed accurately according to the user requirements and performance monitoring.

Environment: Informatica Power Center 8.1, Informatica Power Connect, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), ETL, Flat files, Erwin, Oracle 9i/8i, PL/SQL, UNIX shell