PROFESSIONAL SUMMARY:

• Over 7+years of experience in Information Technology in requirement gathering, data analysis, design, development of software applications and expertise in Data warehousing solutions usingInformatica Power Center.
• Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x and Power Exchange B2B, Data Warehouse Designer, Data mart, OLAP, OLTP.
• Strong knowledge in all phases ofSoftware Development Life Cycle(SDLC).
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets
• Having good knowledge on Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Data Modeling experience in dimensional modeling using Star and Snowflake schema across the Data Warehouse requirement.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Well - honed SQL and PLSQL script writing skills utilizing Oracle 9i, 10g, and 11g.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Extensively worked on ETL Informatica transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Involved in Analyzing/ building Teradata EDW using Teradata ETL utilities and Informatica.
• Involved in Unit testing, Iteration testing to check whether the data transmitted to HDFS(Hadoop) are accurate, which was extracted from different source systems according to the user requirements.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools: Informatica, SQL server SSIS, DataStage, Talend

Data Modelling: Star Schema, Snow Flake, FACT and Dimension Tables, Physical and Logical Modelling, Normalization and Denormalization

RDBMS: Teradata V2R12/V2R6, Oracle 11g/10g, SQL Server 2005/2000, DB2 UDB, MS Access 2000, Sybase

Job Scheduling: Autosys, Unix Shell Scripting, Tidal, TWS

Operating System: Windows 7, Windows Vista/XP/2000, UNIX/Linux

Development tools: SQL Developer, SQL *PLUS, TOAD, SQL Navigator, Crystal Reports, TSA

Programming: SQL, PL/SQL, Python, UNIX Shell Scripting

BI Tools: Tableau, ClickView, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• 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 SCD and Type 2 SCD 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 Center 8.6.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, UNIX AIX, Toad 9.0

Confidential, Minneapolis, MN

ETL/Informatica Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Worked in Development, Testing, Pre-production and Production Servers.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Created complex reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
• Created reusable Sessions and Commands in the Workflow Manager.
• Created and implemented variables and parameters in the Mapping Designer.
• Created reusable Worklets in Worklet Designer and set up Workflows in the Workflow
• Used unconnected lookup for populating date-time entered field in the target tables.
• Developed mapplets, mappings and configured sessions.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Worked closely with reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services, XML, Java, Windows NT, UNIX Shell Scripting.

Confidential, Kansas, KS

ETL Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.5, Oracle 10g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential

Informatica Developer

Responsibilities:

• Involved in requirement designing, and development of data warehouse environment.
• Developed Mappings using various transformations like connected/unconnected Lookups, Filter, Stored procedure, Sequence Generator, Update strategy and Joiners etc. depending upon requirement.
• Used Repository Manager to create user groups and user profiles with privileges of Administrator and Setting up the security for creating user groups and assigning privileges.
• Used the workflow manager to create sessions and batches.
• Created concurrent batches in workflow Manger to run the mappings in a scheduled manner.
• Extensively used debugger to find out errors in mappings and later fixed them.
• Tuned existing mappings, targets, sources, sessions and SQL queries to improve the performance of work units.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Provided the Production Support by running the jobs and fixing the bugs.
• Developed Exception programs to maintain and clean up data exceptions.
• Created, scheduled, and monitored the sessions and batches on the basis of run on demand, run on time using Informatica PowerCenter.
• Experienced in partition of data for better performance of sessions.

Environment: Informatica PowerCenter 8.1, Oracle 9i, SQL, UNIX, MS SQL Server, TOAD, Windows XP

Confidential

Data warehouse Developer (ETL / Informatica)

Responsibilities:

• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
• Extensively used ETL to load data from Oracle, flat files to Oracle.
• Extensively used aggregator, expression, lookup, and update strategy, transformation
• Understanding the ETL Specification Documents for Mappings requirements.
• Extract Data from multiple sources like Flat files, Oracle into staging database.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to design, Develop and Mapplets to load data from external flat files and RDBMS.
• Created Mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Joiner, Union, Sequence Generator, and Update Strategy.
• All errors encountered were documented using an Issue Log. Interacted with team Members to resolve the errors encountered.
• Performed Unit tests on all the Mappings developed and documented the test cases and test results.

Environment: Informatica 7.1.1, Oracle 8i, PL/SQL, Toad 9.4, ERWIN, Web Services, Windows NT, UNIX Shell Scripting.