SUMMARY

• Having 13+ years of experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Enterprise Data Warehousing: Experience and Expertise in ETL process Using Informatica Power Center 9.5.1, Informatica Data Quality 9.1.0, Informatica Analyst 9.1.0 and Informatica Power Exchange 9.5.1.
• Knowledge in working wif IDQ workbench and IDQ components.
• Worked on developing Informatica mappings, workflows, sessions. Also, worked on different transformations like SQ, Joiner, Maplets, Normalizer, Rank, Router, Update strategy, Web services and XML generators, Lookup, Filter, Sorter and Expression etc.
• Expertise in implementing teh XML, Web Services and HTML Transformations along wif Salesforce methodology under Informatica cloud and also implemented Error handling methodologies.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing teh full history of accounts and transaction information.
• Experience on Informatica Administration tasks like Informatica installation, up gradation, set up new users and collects Informatica stats, logs.
• Good experience is maintaining teh versioning and deployment instruction documents while moving teh code to various environments.
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Experience in providing On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner).
• Good working knowledge on RDBMS (Oracle and DB2).
• Good knowledge on writing teh PL/SQL Scripts like Procedures, Triggers and Functions.
• Has extensively worked on creating teh IDE profiling, Dashboards, Informatica Analyst rules, Trend charts, profiling, and score cards.
• Involved in Unit Testing and Data Validation for Developed Informatica Mappings.
• Team player wif excellent communication and problem solving skills and exposed to various design and presentation tools like Visio and MS - Office utilities.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 7.1/8.x/9.1.0/9.6, Informatica Data Quality 8.6, Informatica Developer 9.x, Informatica Power Exchange 9.x, Informatica Cloud 9Informatica Analyst 9.x, Web Services, Informatica Admin Console

Data Modeling: CA Erwin, Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, Fact & Dimensions Tables

Databases: Oracle 8.0/9i/10g/11g, SQL Server 2008 R2, My SQL, DB2, Teradata

OLAP Tools: OBIEE 10g, 11g, Business Objects (Crystal reports).

Prog Language: Java, SQL, PL/SQL, BTEQ

Tools: and Utilities: Toad, SQL Developer, UC4, TWS

Scripting: Perl, Bash, Shell Script

PROFESSIONAL EXPERIENCE

Sr ETL Developer

Confidential

Responsibilities:

• Involved in requirement gathering, user meetings, discussing teh issues to be resolved and translated teh user inputs into ETL design documents.
• Understanding teh Business requirements and prepared a functional spec.
• Extracted data from various heterogeneous sources like Oracle and Flat files.
• Converted teh logical data model into physical data model and communicated wif DBA to implement teh Physical Database.
• Worked wif Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Created a Mapping for load from LANDING tables to STG tables and STG tables to Base Objects
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, XML transformation, Normalizer Transformation and Java Transformation in Informatica
• Worked on different IDQ / Informatica Developer components/transformations like Case, Comparison, Key Generator, Labeler, Match, Parser, Standardizer, Weight, Exception, Rule Based Analyzer, Lookup, SQL, Expression etc. and created IDQ mappings.
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Set up TWS jobs to run Informatica workflows and Perl Scripts.
• Developed Batch scripts for doing automated file transfer to customer via FTP, SCP and SFTP.
• Migrated teh code from DEV repository to QA and then to PROD Repositories while in our monthly releases
• Worked wif PMCMD and PMREP commands to run workflows, tasks, Object Export, Object Delete, find checkouts, connections, Validate, Modify Folder Owner and Permission

Environment: Oracle 11i, Informatica Power Center 9.5.1, Informatica Developer 9.5.1, Informatica Analyst 9.1.0, SQL SERVER, ER Win, Quick view, TWS

Sr ETL Informatica

Confidential

Responsibilities:

• Understanding teh Technical Spec and Develop an ETL process to load data from source to target.
• Involved in requirement gathering, user meetings, discussing teh issues to be resolved and translated teh user inputs into ETL design documents.
• Extracted data from various heterogeneous sources like Oracle and Flat files.
• Designed teh conceptual data model and worked wif teh Business analysts and technical teams to design and update teh logical data model in various iterations.
• Responsible for data mapping, metadata maintenance and enhancing Conceptual, Logical and Physical data models.
• Worked wif Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT, Normalizer Transformation and Java Transformation in Informatica
• Working on Informatica Developer(Informatica Data Quality)9.5.1 and Informatica Analyst9.5.1 to cleanse and profile teh data
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated wif DBA to create sources, targets and views.
• Developed Batch scripts for doing automated file transfer to customer FTP.
• Migrated teh code from DEV repository to QA and then to PROD Repositories while in our monthly releases. And Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all teh monthly releases.
• Created test cases and completed unit, integration and system tests for Data Warehouse and Data mart.

Environment: Oracle 11i, Informatica Power Center 9.5.2, Informatica data quality 9.1.0 Informatica Analyst 9.1.0, SQLSERVER, Erwin 9.x, Sales Force.

ETL Informatica Developer/Lead

Confidential

Responsibilities:

• Leading as an Onsite/Offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact (POC) for teh offshore team
• Responsible for requirement gathering, user meetings, discussing teh issues to be resolved and translated teh user inputs into ETL design documents.
• Designed teh conceptual data model and worked wif teh Business analysts and technical teams to design and update teh logical data model in various iterations.
• Identified teh fact tables, dimensions and teh key measures.
• Worked wif Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile teh data
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated wif DBA for tuning sources and targets and calculating table space and growth of database.
• Migrated teh code from DEV repository to QA and then to PROD Repositories while in our monthly releases and worked on Oracle BI Answers to build Interactive Dashboards wif drill-down capabilities in OBIEE.
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all teh monthly releases and created test cases and completed unit, integration and system tests for Data Warehouse.
• Involved in Production support and ON-Call support.

Environment: Oracle 11i, Informatica Power Center 8.6, 9.x, 9.5.1, Informatica data quality 9.1.0 Informatica Analyst 9.x, Informatica MDM 9.x, UNIX, OBIEE 10.1.X and My SQL.

ETL Developer

Confidential

Responsibilities:

• Understanding Business Requirements and Develop an ETL process to load from source to target.
• Regular interaction wif teh client to get clarity on any business related queries
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator Expression, Joiner, lookup, Filters, Router and update strategy.
• Used mapping designer to generate different mappings for different loads and did performance tuning at mapping level.
• Created maplets and reusable transformations.
• Created and executed sessions using Workflow Manager.
• Monitoring sessions by using Workflow Monitor.
• Deploying teh Informatica objects to Production Server and scheduling them.

Environment: Oracle 10g, Informatica Power Center 8.6, UNIX and Toad

Sr. Analyst

Confidential

Responsibilities:

• Requirements gathering by teh business and analyzing teh existing System
• Responsible for getting teh Customer, Development, design and coding approval and sign-off teh same.
• Translate business requirements into technical specifications
• To get clear Idea on customer requirements before coding phase itself sample file sent to Customer
• Regular interaction wif teh client to get clarity on any business related queries
• Involved in UNIT and Integration Testing
• Involved in creation of reports
• Involved in Production Support and ON-Call Activities
• Direct Interaction wif End Client to solve issues

Environment: IBM 9672, PC, MVS/ESA, JES2, TSO ISPF/PDF, REXX, DB2, CICS, BMS, COBOL, CSP, SPUFI, QMF, FILE-AID, ABEND-AID, ENDEAVOR, XPEDITOR, JCL, MQSeries, IEF, SDSF, MS-WORD, MS-EXCEL, OS/2.