PROFESSIONAL SUMMARY:

• 9+ years IT experience in Analysis, Design, Development, Implementation, Testing & Support of Data Warehousing & Data Integration Solutions using Informatica PowerCenter and PowerExchange using Informatica best practices.
• Proficient in Data Warehousing concepts with emphasis on ETL & Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Extensive experience in ETL of data from various sources into Data Warehouses & Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow manager, Workflow Monitor).
• Hands on experience in data warehousing techniques such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2 & Change Data Capture (CDC).
• Good understanding & experience in Entity Relationship, MultiDimensional - Star & Snowflake schema model, Conceptual, Logical and Physical Data Modeling using ERWIN & Power Designer.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Expertise in creating Transformations, Mapplets & Mappings using Informatica Designer & Workflows, Worklets & Tasks using Workflow Manager to move data from multiple sources into targets.
• Adept in Business Intelligence and Teradata. Demonstrated skills in dimensional Data Marts.
• Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2008, Teradata 14/13/12/V2R5 and MS Access.
• Experience in UNIX shell scripting to support the ETL process and automation.
• Experience working with PL/SQL Procedures, Packages, Functions & Triggers.
• Worked with different data sources like Flat Files, Cobol Sources, Salesforce.com (SFDC) and relational sources like Teradata, Oracle & SQL Server.
• Expertise in doing performance tuning. Using pushdown optimization techniques to optimize transformations and improve performance.
• Good knowledge of Validation testing procedures and processes, Software Development Life Cycle (SDLC) & QA Life Cycles and Agile environment.
• Thorough knowledge of all facets of testing - Unit, Smoke, Functional, System Integration, White Box, Black Box, Regression, User Acceptance Testing, Load, Stress & Volume testing.
• Interacted with developers & product analysts regarding testing status & Defect Tracking.

TECHNICAL SKILLS:

Operating Systems : Windows XP/vista. UNIX, Linux.

ETL Tools : Informatica Power Center 8.5/8.6/9.1/9.5/9.6.1 , Informatica Power Exchange 9.1/9.5/9.6, Informatica Data Quality 9.1/9.5

Databases : Oracle 10g/11g, DB2, DB2 UDB, MS-SQL Server 2000/2005/2008 , Sybase 10, Teradata 12/13/14, My SQL and MS-Access

Languages : C, C++, C#.Net, ASP .NET, UNIX Shell Scripting, PL/SQL, T-SQL

Reporting Tools : Siebel Analytics 7.3(OBIEE) Business Objects

Tools : TOAD, MS VISUAL STUDIO, MS VISIO, SQL *PLUS, SQL Loader,

Modeling : ERWIN 4.1, Power Designer 6.0, Oracle Designer 2000

PROFESSIONAL EXPERIENCE:

Confidential, East Moline, IL

ETL Informatica Developer

Responsibilities:

• Collaborating with business users, subject matter experts to gather requirements and closely working with support team to document the requirements, procedures and standards.
• Worked with Data Architects during design Landing, Stages and OLAP.
• Designed the Source to Target (Mapping document) mappings and involved in designing other documents as per company standards.
• Developed complex mappings using various transformations in Informatica such as Lookup, Filter, Router, Joiner, Update Strategy, Aggregator, Sorter, Expression and Sequence Generator and complex transformations like SqlT, Java, xml p/g transformations.
• Involved in unit testing and documentation of the ETL Process.
• Performance tuning of Informatica Mappings by optimizing the source, optimizing the target, optimizing the transformations and optimizing the sessions.
• Worked with DBA for partitioning and creating indexes on tables used in Source Qualifier queries to improve performance.
• Involved in performance tuning of Oracle Queries. Generation/ interpretation of explain plans and tuning SQL to improve performance.
• Working with Onsite and Offshore team & coordinate with different teams for testing & migration.
• Worked on PowerExchange and created DataMap, Registration, restart tokens.
• Created IDQ mapplets, used various transformation like standardizer, exception, match and worked on Profiling for address, email, cell no and many more components.
• Developing UNIX Shell scripts for processing, extracting and directing the feeds to multiple other Systems/Vendors.
• Used debugger to test the mappings and fixed the bugs, resolved many production issues.
• Developed ETL mappings from staging area to 12 different report tables.

Environment: Informatica Power Center 9.6, Informtica PowerExchange 9.6, Flat files, XML Control-M Scheduler, Teradata 14, Informatica IDQ 9.6, Informatica Cloud Services and ERWIN 4.1

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

• I was responsible to develop the whole ETL process and maintain/Production support.
• Worked with lead Business analyst to identify the source systems.
• Used Talend Data profiler to do the data profiling.
• Worked with the Data Modeler during the designing of Logical and physical models.
• Worked with client team while designing requirements document.
• Performed Data cleansing and data scrubbing on the source systems.
• Implemented transformations on the source systems as per requirements and loaded them into a Landing zone.
• Extensively used ETL Tool Informatica to load data from Flat Files to landing tables in SQL server.
• Worked with the client to perform extensive validation of landing tables.
• Implemented Star schema for this Data Warehouse.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from landing tables to Dimension tables.
• Implemented Slowly Changing Dimensions (SCD-2) for loading the dimension tables.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Informatica Repository Manager & Informatica Workflow Manager.
• Responsible for error handling using Session Logs, Reject Files & Session Logs in the Workflow Monitor and tested all the Informatica mappings and update processes. 
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and arranged them in various workflows in the workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Worked on Teradata utilities like FLOAD, MLOAD and TPT for various loads.
• Developed Unit test cases and Unit test plans to verify the data loading process and also perform regression test.

Environment: Informatica - PowerCenter 8.6/ 9.1.0/9.5.1 ,Informtica PowerExchange 9.1.0/9.5.1 , SQL Server 2008 R2,Teradata 14/13, SQL Server 2008, Rally, Basecamp, Business Intelligence Development Studio.

Confidential, Richmond, Virginia

Informatica Developer

Responsibilities:

• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model's with Architecture teams. 
• Studied the process, subject areas and data flow for current datawarehouse and analyzed the data flow Re-Point to the Staging area.
• Accumulated the details of all 10 processes, integrated the modules and designed single data flow diagram that includes all processes for IHUB as well as DSH.
• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Created Technical Specification documents using MS Visio and maintained Technical specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from source systems SQL Server into target systems in different database, by applying business logic on transformation mapping for inserting and updating records when loaded.
• Worked with mappings that moved data by the Slowly Changing Dimensions (SCD-2). Hence worked on movement of the new and updated data.
• Loaded data into Teradata database as per the specifications.
• Wrote Teradata BTEQ scripts to extract data from base tables to intermediate working database.
• Involved in loading of data from flat files using complex MLOAD scripts and FASTLOAD scripts.
• Created mappings in Informatica 9.x to pull data from Teradata and load into Oracle Data warehouse.
• Written PL/SQL procedures to perform data base activities like index creation, dropping and updating database tables.
• Built mappings that now move data through staging area DSH instead of the earlier IHUB.
• Developed SQL scripts as per the business requirements to test informatica code.
• Changed the metadata framework, maintained framework documents for all 10 processes. Created new process IDs and related parameters. Moved in the metadata pertaining to DSH by executing the SQL generator.
• Changed and validated session properties and connections such that they now point the data to DSH.
• Created folders for all processes in the HMC portal and uploaded the configuration file and ini file.
• Performed Unit testing for all 10 processes and maintained the unit test logs.
• Used tidal scheduler to insert the process jobs & implemented them successfully after checking for errors.
• Created artifacts list to migrated changes to SIT (System Integration Testing) and then to production. Artifacts list consists of changes to database objects, Informatica objects, flat files, sandbox scripts, frame work, job scheduler and Meta data migration scripts.
• Worked with SIT team to create test data for SIT purpose & supported in migration to production.
• Provided all the documentation for DDM project by uploading them into MS Visual Source Safe and maintained them by creating appropriate folders and versions.
• Provided primary on-call production support for all enterprise Informatica environments.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.6.1, Informatica PowerExchange 8.6.1, MS SQL Server 2008, MS Visual Source Safe, Tidal Scheduler, Windows XP, Teradata 13, MS Visio.

Confidential, Denver, Colorado

Informatica Developer

Responsibilities:

• Interacted with various business team members to gather the requirements & documented the same.
• Designed logical and physical data models for CIS and PMS data marts to be fed from legacy systems using Erwin7.1.
• Developed and maintained the technical design documents of ETL process.
• Performed data analysis and worked with System owners to resolve source data issues.
• Designed and built ETL processes to extract and load high volume of data from different source systems such as VSAM Cobol files,Mainframe, RDBMS, Web Services, XML and Flat Files.
• Having a thorough understanding of these current & potential requirements & helped the Data Architect & Project Manager to design a flexible & scalable solution that meets the needs of the business.
• Developed reusable transformations, mapplets and shortcut to prevent redundancy.
• Created Deployment Group and performed objects migration.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Effectively balance and prioritize multiple projects concurrently
• Developed SQL queries, T-SQL, and PL/SQL programs for complex data requests.
• Wrote shell scripts to perform Repository backup, logs cleanup on regular basis and automated the daily load process across the systems.
• Created and executed unit tests on all solutions, worked with Data analysts and QA team to ensure solutions are well tested, production ready and well documented.
• Provided primary on-call production support for all enterprise Informatica environments.
• Trained internal employees on Informatica and got them to the pace of development. 

Environment: Informatica PowerCenter 8.6, PowerExchange 8.6, SalesForce.com, Relational Junction for SalesForce, DB2, Oracle10g, SQLServer2005, TSQL, Web Services, Mainframe, Cobol, UC4, PL/SQL, Erwin7.1, Unix Shell Script, QualityCenter9.2,  WSDL, and XML.

Confidential

Junior Data warehouse/ Informatica Developer

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Created Technical Specification documents using MS Visio and maintained Technical specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from various source systems such as PeopleSoft, Oracle, DB2, COBOL and Flat Files into target systems Oracle, Siebel, DB2 and Flat files, by applying business logic on transformation mapping for inserting and updating records when loaded.
• Extensively used the Designer to import source and target definitions into the repository and to build mappings.
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows, tasks and sessions.
• Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Developed SQL/Perl scripts for the daily flat file extraction.
• Applied Performance Tuning logic at mapping and session level.
• Developed PL/SQL stored Procedures and Functions to enhance backend functionality.
• Wrote Shell scripts to schedule the jobs.
• Provided primary on-call production support for all enterprise Informatica environments.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.1, Oracle, Sunopsis Data Integrator,DB2, MS Access, FirstLogic, PL/SQL,, Shell Script, Perl, Cobol, Toad7.2, QMF8.1, Windows2000, Mainframe, MS Visio