SUMMARY

• Around 8 years of experience on Extraction, Transformation and Load (ETL) of data from Legacysystems using Informatica (9.1.0/9.0.1/8. x).
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience with dimensional modeling using Star Schema and Snowflake models.
• Expertise in Data Warehousing concepts like Bill Inmon methodology and Ralph Kimball methodology, fact tables, dimension tables.
• Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
• Proficient in Informatica Designer components like Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer (Re - usable transformations), Workflow Manager, Workflow Monitor.
• Worked extensively with Slowly Changing Dimensions.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Ability to review project deliverables for completeness, quality, and comply with Project Standards and Specifications.
• Proficient in Oracle 10g/9i/8i/7.3,PL/SQL Development Toad, SQL, PL/SQL, Teradata.
• Excellent analytical, communication, inter-personnel, team player and Leadership skills.
• Ability to learn and adapt quickly to the emerging new technologies.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica 9.1.0/9.0.1/8.6/8.1.2 , Informatica Designer, Workflow Manager and Workflow monitor.

BI Tools: Business Objects.

Programming Languages: C, C++, COBOL.

Database: Oracle 8i/9i/10g/11g, IBM DB2, SQL Server, MS-Access, Teradata.

Operating systems: Windows 95/2000/NT/XP/Vista, UNIX.

Data Modeling Tool: Erwin4.0/4.1.

Utilities: Oracle SQL Developer, TOAD, SQL*LOADER

Job Scheduling Tools: Informatica Scheduler, Control- M

Development Tools: MS Excel, MS Outlook, MS Word, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Informatica Developer

Responsibilities:

• Gathered Requirements from users, translated user inputs into ETL design documents.
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Created complex mappings using expression, Unconnected Lookup, Sorter, Normalizer, Union, Aggregator, Dynamic Lookup and Router transformations for populating target table in efficient manner.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Used Teradata SQL Assistant to run the SQL queries and validate the data.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation of the daily loads and process flow of the mappings and development of Ad hoc Reports.
• Follow-up on tickets and fixing the issues.

Environment: Informatica Power Center 9.1.0/9.0.1 (Power Center Designer, workflow manager, workflow monitor), Teradata, Business Objects, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, Oracle 10g/11g.

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
• Developed the mappings using needed Transformations in Informatica tool according to technical specifications.
• Developed mappings/sessions using Informatica Power Center 9.0.1 for data loading.
• Created Complex mappings that involved implementation of Business Logic to load data intostaging area.
• Developed workflows using task manager, worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.
• Effectively used Informaticaparameter files for defining mapping variables.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and troubleshooting.
• Used Teradata and Oracle as sources for building the datamarts to analyze the business individually.
• Created command files and used Control-M for running the jobs to make sure all dependencies (mappings) are in good shape before moving the code to production.
• Generated DML Queries for manipulating database objects like tables, views, using insert, update and delete commands.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Monitor and communicate the availability of Informatica Environment. Follow-up on tickets and fixing the issues.

Environment: Informatica Power Center 9.0.1(Power Center Designer, workflow manager, workflow monitor), SQL, PL/SQL, Business Objects, Teradata, Oracle 9i, TOAD, MS-Project, Visio, MS-Word, MS-Excel, DB2, Control-M.

Confidential, Ann Arbor, MI

Informatica Developer

Responsibilities:

• Understanding business needs and implement the same into a functional database design.
• Participated in requirements gathering.
• Involved in all the phases of SDLC.
• Developed new Informatica mappings and workflows based on specifications.
• Developed Batch Processing, Source and Target Reconciliation.
• Performed extraction, transformation and loading of data from RDBMS tables, Flat Files into Teradata in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Created Netezza DB Objects using best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Created NZLoad scripts to load the Flat Files into Netezza staging tables.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked with production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.0.1, Teradata TD 13, Netezza, UNIX, Flat files, Windows 7 Professional.

Confidential, Long Island, NY

Informatica Developer

Responsibilities:

• Gathered requirements required by the client.
• Developed user requirements and Functional/Technical specifications.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Promoted Informatica mappings from development to test to production environment.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Developed technical system documentation.
• Monitor and communicate the availability of Informatica Environment. Follow-up on problem tickets

Environment: Informatica Power Center 8.6, PL/SQL, Oracle 10g/9i, Erwin 4.5/4.0, DB2, HP-UNIX 10.20, Toad, OBIEE, Microsoft Tools (excel,visioetc).

Confidential

ETL/Database Developer

Responsibilities:

• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer
• Identify source systems, connectivity, tables, and fields, ensure data suitability for Mapping
• Used SQL Over rides in Source Qualifier and Lookups to improve mapping performance.
• Implemented the slowly changing dimensions as per the requirements.
• Created sessions and executed them to load the data from the source system using Informatica Workflow Manager

Environment: Informatica Power Center 8.6, Oracle 9i, PL/SQL, Business Objects 6.5, Shell scripting, Sun Solaris UNIX, Windows 2005.

Confidential

Jr ETL Developer

Responsibilities:

• Designed the ETL Mapping Documents for development team members for their implementations.
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Promoted Informatica mappings from development to test to production environment.
• Used Informaticato extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
• Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Follow-up on tickets and fixing the issues.

Environment: Informatica 8.1.2, Oracle 10g, SQL, PLSQL, Microsoft Excel, MS-Word, COBOL.