SUMMARY

• Over 12+ years of IT experience in Data warehousing and Business intelligence wif emphasis on Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and Data Mart systems.
• Extensively involved in creation of mappings wif using Informatica Power Center.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle into a common target area such asData Marts and Data Warehouse.
• Experience in interacting wif Business users in analyzing teh Business process requirements and transforming them into documenting, designing, and rolling out teh deliverables.
• Experience in DW/BI wif a skill set of Informaticawif good understanding of Data Warehousing Concepts and Data Modeling.
• Experience in Data Warehousing Domain using Informatica Power Center 9x/8x/7x.
• Experience in Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
• Strong experience in Oracle SQL & PL/SQL and programming database and Microsoft SQL Server.
• Creating Scripts, Jobs, Workflows, Data Flows and Executing jobs wif Data Integrator Designer. Loading Data into Target using flat files and from database tables used as source files.
• Excellent experience in developing Transformations.
• Excellent experience on ETL Testing.
• Excellent communication skills, technically competent and result - oriented wif strong problem solving skills.

TECHNICAL SKILLS

ETL: Informatica 9x/8x/7x, IDQ 8.6.1

Operating Systems: Windows 98/2000/NT

RDBMS: Oracle 9i, 10g, 11I, R12, Teradata.

DBMS: PL/SQL, SQL, Microsoft SQL Server

Other Tools: Toad, SQL Developer, Teradata SQL assistant, Unix, HPQC

Reporting Tools: Business Objects, QlikView, Tableau

PROFESSIONAL EXPERIENCE

Confidential, BalaCynwyd, PA

Technical Lead

Responsibilities:

• Understanding teh Functional specification document and Business Requirements.
• Requirements gathering to implement teh project need.
• Identified and eliminated duplicates in datasets thorough IDQ 9.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables teh creation of a single view of customers, halp control costs associated wif mailing lists by preventing multiple pieces of mail.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Working wif Informatica Data Quality (IDQ) plans to identify possible data issues
• Design all programs and systems and associate documentation for same.
• Data validation and Unit Testing as per requirements.
• Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.
• Design all test cases to provide support to all systems and perform unit tests.
• Working wif different transformations for creating and developing mappings.
• Working wif Source Qualifier queries to load target database.
• Implementing teh Change Requests from Client side.
• Moving output files to DNB FTP server through Informatica command tasks.
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2012.

Environment: Informatica Power Center 9.6.1, IDQ 9.1, Microsoft SQL Server 2012,Unix.

Confidential, Cincinnati OH:

Technical Lead

Responsibilities:

• Understanding teh Functional specification document and Business Requirements.
• Requirements gathering to implement teh project need.
• Administer all requests and analyze issues and provide efficient resolution for same.
• Setup Configuration pointing to R12 database Building a process in IDQ for cleansing and migrating global customer data from Oracle 11i into 12i.
• Profiled teh data usingInformatica Data Explorer(IDE) and performed Proof of Concept forInformatica Data Quality(IDQ).
• Design all program specifications and perform required tests in same.
• Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.
• Design all programs and systems and associate documentation for same.
• Prepare all program and system implementation for all informatics programs.
• Monitor all production issues and inquiries and provide efficient resolution for same.
• Design all test cases to provide support to all systems and perform unit tests.

Environment: Informatica Power Center 9.1, IDQ 8.6.1,Tableau,Oracle 11i/R12, Unix,HPQC.

Confidential, Atlanta GA

Sr. ETL/Informatica Developer

Responsibilities:

• Understanding teh Functional specification document and Business Requirements.
• Requirements gathering to implement teh project need.
• Developed mappings using Informatica Designer to load teh data into target database.
• Weekly Data load and validating teh data
• Worked on Informatica Power Center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Unit testing for teh mappings as per requirements.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Working wif Informatica Data Quality (IDQ) plans to identify possible data issues
• Extensively used data validations, data quality, data profiling and extensively used transformations to load teh data into teh data ware house.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin r7.2.
• Used Delta loads using map operation, table comparison, history preserving and key generation and also full loads.
• Loaded teh Customer data into Data warehouse on a monthly basis using Informatica.
• Scheduled, monitored and fixed teh errors of teh jobs.
• Optimized Data Flows to achieve faster load.
• Preparing teh Weekly Alert Reports.

Environment: Informatica Power Center 9.1, IDQ 8.6.1,Oracle 11g,SQL Developer, QlikView,Unix,Windows NT.

Confidential, Cincinnati, OH

Sr. ETL Developer

Responsibilities:

• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline teh proposed solution.
• Build teh new universes as per teh user requirements by identifying teh required tables from Data mart and by defining teh universe connections.
• Profiled master data objects based on teh various dimensions i.e., Conformity, Uniqueness, Consistency, Business Relevancy, Data Accuracy and Integrity.
• Profiled teh data usingInformatica Data Explorer(IDE) and performed Proof of Concept forInformatica Data Quality(IDQ).
• Involved in building teh ETL framework for teh extraction and transformation of data from different source systems.
• Developed teh ETL jobs for run daily basis.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data
• Taking sources as a flat files/Excel spread sheets implemented necessary transformations to extract, transform and load teh data into oracle tables in teh Rapidmarts data ware house.
• Implemented Security Features of Business Objects like row level, object level and report level to make teh data secure.
• Developed universe user documentation guide for teh end users reference.
• Understand teh components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin r7.1.
• Created teh Test cases and Captured Unit test Results.
• Fine Tuned SQL Queries for maximum efficiency.

Environment: Informatica Power Center 9.1,Teradata SQL assistant, IDQ 8, Oracle 10g, Unix, Windows NT.

Confidential, Dallas, TX

Sr. ETL Developer

Responsibilities:

• Understanding teh Functional specification document and Business Requirements.
• Developed mappings using Informatica Power Center Designer to load teh data into target database.
• Testing teh Mapping and Workflows.
• Worked on Informatica Power Center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Working wif different transformations for creating and developing mappings.
• Working wif Source Qualifier queries to load target database.
• Implementing teh Change Requests from Client side.
• Unit Testing for teh mappings as per requirements.
• Extensively used data validations, data quality, data profiling and extensively used transformations to load teh data into teh data ware house.
• Used Delta loads using map operation, table comparison, history preserving and key generation and also full loads.
• Loaded teh Customer data into Data warehouse on a monthly basis using Informatica.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin r7.1.
• Worked on DEV, QA and PROD and successfully resolved all teh defects.
• All teh data that is loaded onto teh data ware house TEMPhas been used for reporting purposes.

Environment: Erwin r7.1,Informatica Power Center 9.1, Oracle 10g,SQL Developer, Unix, Business Objects,Windows NT.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Developed mappings using Informatica Power Center Designer to load teh data into target database.
• Worked on Informatica Power Center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Worked wif different transformations for creating and developing mappings.
• Worked wif Source Qualifier queries to load target database.
• Used SQL tools like TOAD to run SQL queries and validate teh data loaded into teh target tables.
• Worked extensively increating jobs, extract in scope and transform jobs.
• All jobs include extensive work onextract teh data from different sources. Built extract jobs in order to extract teh data into staging.
• Built in scope jobs in order to extract data only to get teh data as per business requirements.
• Worked extensively on teh transform job in order to complete teh required three steps. 1. Remediation 2. Data quality management and data profiling 3.Deduplication.
• Extensive experience in trouble shooting in resolving teh defects and also loading teh data in DEV, QA and PROD environments.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin r7.1.
• Extensive team meetings wif business people in order to assimilate teh business requirements and also in terms of deadlines and requirement estimation.

Environment: Erwin r7.1,Informatica Power Center 8.6, Oracle 10g,SQL Developer,Unix, Business Objects,Windows NT.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Worked wif teh Business Users and captured simple, moderate and complex business requirements. Collaborated wif Data Warehouse Team to research existing business and system processes.
• Developed mappings using Informatica Power Center Designer to load teh data into target database.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Worked wif different transformations like Source Qualifier, filter, Aggregator, Expression, Lookup, Sequence Generator, Router and Update Strategy transformations.
• Playedan active role in preparing teh Unit Test cases for individual mapping.
• Interacted wif business analysts and End clients to understand technical and functional requirements for creating new ETL Jobs.
• Established process for business to modify teh hierarchies used in teh system wif minimal impact on IT.
• Developed a new job of SCD - Type 2, to populate teh hierarchies on a daily basis.
• Scheduled, monitored and fixed teh errors of teh jobs.
• Optimized Data Flows to achieve faster load.
• Included teh two aggregate tables and applied aggregate awareness on all teh Profitability and Balance Analysis to speed up teh query time.
• Used teh Aggregate Navigation in order to setup teh compatibilities and incompatibilities of objects for each level of aggregation.

Environment: Informatica Power Center 8.1/8.6, Oracle Warehouse Builder, Oracle 10g,Windows NT.

Confidential

ETL developer

Responsibilities:

• Involved in business analysis and technical design sessions wif business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Developed mappings using Informatica Power Center Designer to load teh data into target database.
• Worked on Informatica Power Center - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Worked wif different transformations like Source Qualifier, filter, Aggregator, Expression, Lookup, Sequence Generator, Router and Update Strategy transformations.
• Prepared teh Unit Test cases for individual mapping.
• Developed various mappings for extracting teh data from different source systems using Informatica Power Center - Server, Workflow Manager, Repository Manager and Designer
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Created Mapping Parameters and Variables.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load teh data from Staging area to DW
• Developed Mapplet using corresponding Source, Targets and Transformations and for reusable business rules.
• Created and monitored sessions and workflows using Workflow Manager.
• Developed Informatica mappings for Type 1 Slowly Changing Dimensions.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Experience in scheduling ETL jobs through Autosys.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Used teh Debugger to run Debug sessions setting Breakpoints across instances to verify teh accuracy of data.

Environment: Informatica Power Center 7.1, Oracle Warehouse Builder, Oracle 9i,Toad,UNIX,Windows NT.

Confidential

ETL Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about teh financial system.
• Extensively used Informatica Power Center 7.1.1 to load data into Data Warehouse.
• Responsible for Extracting, teh data from Relational sources & Flat files and placing it into Data Warehouse.
• Most of teh transformations used like Source Qualifier, Aggregator, Look Up, Filter, Sequence Generator, Joiner and Update strategy, Router etc.,
• Involved teh Unit Test cases for individual mapping.
• Developed various mappings for extracting teh data from different source systems using Informatica Power Center - Server, Workflow Manager, Repository Manager and Designer
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Created Mapping Parameters and Variables.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load teh data from Staging area to DW
• Developed Mapplet using corresponding Source, Targets and Transformations and for reusable business rules.
• Created and monitored sessions and workflows using Workflow Manager.
• Developed Informatica mappings for Type 1 Slowly Changing Dimensions.

Environment: Informatica Power Center 7.1, Oracle 9i, UNIX, Toad, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Responsible for Extracting, teh data from Relational sources & Flat files and placing it into Data Warehouse.
• Most of teh transformations used like Source Qualifier, Aggregator, Look Up, Filter, Sequence Generator, Joiner and Update strategy, Router etc.,
• Involved teh Unit Test cases for individual mapping.
• Developed various mappings for extracting teh data from different source systems using Informatica Power Center - Server, Workflow Manager, Repository Manager and Designer
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Created Mapping Parameters and Variables.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load teh data from Staging area to DW
• Developed Mapplet using corresponding Source, Targets and Transformations and for reusable business rules.
• Created and monitored sessions and workflows using Workflow Manager.
• Developed Informatica mappings for Type 1 Slowly Changing Dimensions.

Environment: Informatica Power Center 7.1, Oracle 9i,Toad,UNIX,Windows NT.

Confidential

ETL Developer

Responsibilities:

• Extensively used Informatica Power Center 7.1.1 to load data into Data Warehouse.
• Responsible for Extracting, teh data from Relational sources & Flat files and placing it into Data Warehouse.
• Most of teh transformations used like Source Qualifier, Aggregator, Look Up, Filter, Sequence Generator, Joiner and Update strategy, Router etc.,
• Involved teh Unit Test cases for individual mapping.
• Developed various mappings for extracting teh data from different source systems using Informatica Power Center - Server, Workflow Manager, Repository Manager and Designer
• Extensively used Informatica tools – Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Created Mapping Parameters and Variables.
• Developed mappings using Informatica Power Center Designer to load teh data into target database.
• Worked on Informatica – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Worked wif different transformations like Source Qualifier, filter, Aggregator, Expression, Lookup, Sequence Generator, Router and Update Strategy transformations.
• Playedan active role in preparing teh Unit Test cases for individual mapping.
• Developed Informatica mappings for Type 1 Slowly Changing Dimensions.

Environment: Informatica Power Center 7.1, Oracle 9i,Toad,Windows NT.