SUMMARY

• 4 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using InformaticaPowerCenter9.5/9.1/ 8.x/ 7.x.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access.
• Experienced in loading and maintaining Data Warehouses in Teradata. Extensively used tools are MLoad, BTeq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• DataModelerwith strong Conceptual, Logical and PhysicalDataModeling skills,DataProfiling skills, MaintainingDataQuality, experience with JAD sessions for requirements gathering, creating datamapping documents, writing functional specifications, queries.
• Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files, Netezza into a staging area
• Experience with Mainframe systems (COBOL, JCL, CICS, VSAM, DB2, IMS, IDMS) and also conversion of Mainframedatato ETL Staging tables.
• Expertise in Gathering and Analyzing Information Requirements,DataAnalysis,DataArchitecture, Business (E-R) modeling, Dimensional Modeling, ETL Design.
• Experience in Informatica Power Center 8.x/ 7.1.4/6.2/5.1 with Oracle 9i/10g, 3 years of experience in SSIS and SQL ServerDataWarehouse in Microsoft DW/BI environments.
• Extensively experience withTalend, SQL Server DTS & Integration Services (SSIS) Packages, and Informatica for Extract, Transform, and Load (ETL) Data Warehouse technique, Business Objects Universe Designer, Deski and Webi reporting tools, Microsoft Reporting Services (SSRS) and Integration Services (SSIS) tools, ORACLE, DB 2, and Sybase.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience in working withHadoopeco system.
• Experience working with multi nodeHadoopCluster.
• Experience inUNIXOperating System andShell scripting.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experienced in all data processing phases, from the Enterprise Model, Data Warehousing (ETL)
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Extensive experience using database tool such as SQL *Plus, SQL * Loader
• Good knowledge of business intelligence tool Cognos.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5/9.1//8.x/7.x (PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g10g/9i, MS SQL Server 2008/2005, MS Access and DB2

Languages: SQL, PL/SQL, C, Data Structures, Facets, Unix Shell Script

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Web Technologies: HTML, XML, Java Script

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, Active Batch

Operating systems: Windows NT/2000/2003/XP/VISTA/7,UNIX,MSDOS and LINUX

PROFESSIONAL EXPERIENCE

Confidential, Michigan

Sr. Talend Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using InformaticaPowerCenter.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.
• Responsible for design and developing Teradata BTEQ scripts, MLOAD based on the given business rules and design documents
• Experience in migration Informatica objects from 9.1 to 9.5.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Extensive experience in working with Teradata data link.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.5, Oracle 10g/9i,PL/SQL, Flat files, Facets, XML, MS Access, SQL Server 2008, VSS, Active Batch

Confidential, New York

Talend Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Bussiness rules.
• Used InformaticaPowerCenter 9.1 for extraction, loading and transformation (ETL) of data.
• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Experience in analysis members and providers data.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer &Mapplet Designer and Transformation Developer.
• Involved in complete software development life cycle (SDLC) of the project.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.