SUMMARY:

• More than 8+ years of IT experience in Software Analysis, Development and implementation of business applications for Sales and distribution, Health Insurance, Financial and Telecom verticals.
• 7 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.1/8.6.1/8.5/8.1/7.1/6.2 and Power Mart 6.2/5.1 using Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• 7 years of experience in using Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x.
• Extensive experience in creation and maintenance of database objects like tables, views, materialized views, indexes, constraints, primary keys, sequence, synonyms and database Link.
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced in Performance tuning of targets, sources, mappings and sessions.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet Metadata and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, constructing, and deployment.
• Experience in Teradata and worked on Teradata utilities such as B.TEQ, MLOAD, FLOAD.
• Experienced in data Cleansing experience using Trillium 7.6/6.5 (Macher, Parser, Converter & Geocoder), Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding
• Experienced in integration of various data sources like Oracle, DB2, SQL server and MS access into staging area.
• Expertise in various DW tools that include SAP BODS, SAP Data Insight, SAP Business Objects, SAP-BW/BI, SAP Best Practices for Data Migration solutions.
• Expertise in SQL queries and Query Optimization, Report Testing techniques.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Experienced in BTEQ, FEXP, FLOAD, MLOADTeradatautilities to export and load data to/from Flat files.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Strong documentation skill using Microsoft Word and Excel.
• Hands-on experience with VBA, MS Visual Basic 6.0 (VB 6) and SSIS, SSRS, and SSAS, Dynamic SQL.
• Tidal scheduler for scheduling Informatica jobs.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL Server, XML files, Teradata and loaded into Oracle database.
• Experience with various Online Analytical Processing tools (OLAP) like designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6.1/8.5/8.1/7.1/6.2 , Informatica PowerCenter 9.1/8.6.1/8.1/7.1/6.2 , InformaticaPowerExchange, Metadata Manager, Data Analyzer, DT Studio, IDQ OLAP, OLTP, ODS

Databases & Tools: Oracle 11g/10g/9i/8i, DB2, SQL Server 2010/2005, Teradata, Oracle SQL*Plus, Trillium, SQL Query.

Scheduling and Reporting Tools: Tivoli, Autosys, Tidal, Business Objects XIR3.1/XIR2, OBIEE

Programming Languages: Unix Shell Scripting, SQL, PL/SQL, Perl, Visual Basic

Web Tools: HTML, Remedy 7.0, Erwin 4.0/3.5.2, MS-Visio, TOAD, SQL Developer, SQL Navigator, SQL Server Management Studio, SQL* plus, SQL* Loader, Autosys, Data Studio, i-series Navigator

Environment: UNIX, Win XP/NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Providence, Rhode Island

Sr. ETL/Informatica Administrator

Responsibilities:

• Install Informatica PowerCenter 9.1 and then upgraded it to PowerCenter 9.5
• Folder migrations from PowerCenter 8.6.1 to PowerCenter 9.1 and then to 9.5
• Mentor Informatica developers and Administrators.
• Manage Security and permissions using Admin Console.
• Use Repository Manager for managing Deployment groups.
• Created Informatica Queries to query Informatica Metadata.
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.5
• Migrate param files, source files and target files as needed.
• Creating Standards documents to help developers have a road map of coding standards.
• Assigning security to the developers using Informatica Admin Console.
• Starting and stopping services and server when required.
• Implement Velocity document as suggested by Informatica.
• Help developers tune their workflows and sessions for better performance.
• Create the paper work to buy the software and hardware required for 901 implementation.

Environment: Informatica Power Center 9.5/9.1/8.1,UDB DB2,Unix AIX, SQL Server 2008/2005, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality.

Confidential, Jersey City, NJ

Sr. ETL/ Informatica Developer

Responsibilities:

• Install Informatica PowerCenter 9.1 and then upgraded it to PowerCenter 9.5
• Folder migrations from PowerCenter 8.6.1 to PowerCenter 9.1 and then to 9.5
• Mentor Informatica developers and Administrators.
• Manage Security and permissions using Admin Console.
• Use Repository Manager for managing Deployment groups.
• Created Informatica Queries to query Informatica Metadata.
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.5
• Migrate param files, source files and target files as needed.
• Creating Standards documents to help developers have a road map of coding standards.
• Interacted with Business Analyst to understand the business requirements.
• Involved in developing the logical andphysical data models using Erwin.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
• Used SCD2 to populate the data in a generic way. Single mapping is used to load multiple tables’ data.
• Sourced data from Teradata to Oracle usingFast Exportand Oracle SQL Loader.
• The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Created reusable transformations and mapplets and used them in mappings.
• Established reusable components and implement Informatica best practices and standards.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Used Teradata External loaders like MLOAD, to load data from Flat files into the target tables in Teradata Database.
• Involved in Creating Fact and Dimension tables using Star schema.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources (flat file feeds from Canada, Tokyo and Singapore)
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SSIS.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, DTS and SSIS services.
• Expertise in excellent system documentation which gives extensive information about the dataflow and the methodology which would be more useful to understand about the process.

Environment: Informatica Power Center 9.0/8.6.1, Power Exchange 8.6.1, SQL server2005/2008, Oracle 10g, DB2, PL/SQL, SSIS, SQL Query, TOAD, Data Modeling, Tivoli, SAP, Perl, Teradata, UNIX Shell Scripting, BTEQ, PL/SQL, Flat Files, Windows XP, Unix.

Confidential, Columbus, OH

Sr. Informatica Developer/Production Support

Responsibilities:

• Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Worked with Business analysts for requirements gathering, business analysis and designing of the data warehouse.
• Developed reusable Transformations.
• Widely used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Coordinated with customer in finding the sources and targets for data conversion.
• Created Reusable transformations and Mapplets for use in Multiple Mappings.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Installed, and documented the Informatica Power Center setup on multiple environments.

Environment: Informatica Power Center 8.6.1, Data Modeling, Oracle 9i, SSIS, SAP, DB2, SQL*Loader, Erwin 3.7, TOAD 7.6, Windows 2000, SQL, PL/SQL, Teradata, Business Objects

Confidential, Fremont, CA

Sr. ETL Informatica Administrator

Responsibilities:

• Extensively used Informatica to load data from Flat Files, Mainframes and SQL Server.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Extracted data from Mainframes IMS databases and VSAM files using Power Exchange.
• Used XML as sources and Target in Informatica mappings.
• Extensively used Triggers, Stored Procedures and Functions.
• Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Checked and tuned the performance of application.
• Developed data Mappings between source systems and warehouse components.
• Created and defined DDL’s for the tables at staging area.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Environment: Informatica Power Center 8.6/8.1/7.2, SQL Server 2005/2000, Metadata Manager, MS Access, ER Studio, Microsoft Reporting services, Web services, Data Masking, Data Explorer and Data Quality

Confidential, San Jose, California

Sr. Informatica ETL Developer

Responsibilities:

• Gathered requirements for the scope of migration from Siebel to SFDC.
• Built Integration between SFDC to PRC to run based on Extract Status in SFDC.
• Used Power exchange for Salesforce to connect Powercenter with Backend systems to Salesforce.
• Integrated SFDC to Big machines through Informatica for the opportunities at a bound stage.
• Written Shell scripts to FTP the csv file from Informatica target folder to Big Machines along with the product and customer information.
• Production Support on Informatica development that was built in Phase1.
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Data cleansing reports provided to business for cleansing data on duplicates in Salesforce.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Developed Salesforce Out of the Functionality and built custom objects.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected And unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica PowerCenter Designer.
• Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Also used Sql override instead of Salesforce lookup in order to improve performance by extracting data into staging.
• Involved in Salesforce workshop along with Business user to understand the Telecom business and provided the solutions on Salesforce followed by Informatica design.
• Designed Salesforce configuration to match with the business requirement and involved other team members to create validation rules or Triggers on Salesforce Objects.
• Built ETL mappings from Siebel to Staging( Oracle ) and then further migrated to SFDC.
• Week on Week Status report to manager on the process and Timelines.
• Also used Apex Data Loader to load Partner, Contacts and Partner Addresses data into Salesforce from Siebel CRM’s as a onetime migration.
• Used Informatica Scheduler to schedule Informatica mappings

Environment: Informatica Power Center 9.0.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange for Salesforce, Siebel, Oracle 10g, BIG machines, Eloqua, Apex Data Loader, Linux, Informatica Scheduler

Confidential

ETL Developer

Responsibilities:

• Analyzed requirement specification documents and understands the source data.
• Analyzed requirement specification documents and understands the source data.
• Analyzed HLD and prepared LLD documents.
• Developed ETL to Load Data in staging tables and used SCD Techniques for Loading of Dimension tables.
• Created Mappings, Mapplets, Reusable transformations, Worklets and Workflows.
• Involved in Unit testing of Mappings and Workflows and debugging mappings for failed sessions.
• Used Different Tasks in Workflow such as Command, Session, Email, Event-wait, Event-Raise and Decision etc.
• Performance Tuning of Sessions and Mappings.
• Migrating mappings between Development and QA repositories.
• Involved in Integration Testing.
• Provided support to QA Team.

Environment: Informatica 7.1, ORACLE RDBMS 9i, TOAD, PL/SQL Developer, Windows XP Professional and UNIX.