PROFESSIONAL SUMMARY

• Overall 6 years of experience in Data Warehousing ETL tool INFORMATICA 9.6/9.5/8.6 and 5 years of experience in
• Business Intelligence reporting in Confidential 10.1/10.2/8.4 , experience in Mainframe, Software Testing including UAT.
• Duties are to develop and maintain the ETL environment, processes, and scripts to acquire data from various disparate systems and apply the data to tables in a database for reporting/analytics purposes
• Use data analytics techniques such as data mining to analyze the source data and determine the best reporting structures to build
• Manage the physical and logical data models in support of the data warehouse development and production environments
• Review database design and integration of systems, provide backup recovery and make recommendations regarding enhancements and/or improvements
• Formulate policies, procedures, and standards relating to database management, and monitor transaction activity and utilization
• Direct the activities of Junior ETL Developers
• Strong experience in Extraction, Transformation and Loading(ETL) data from various sources into
• Data Warehouses and Data marts using Informatica Power Center as ETL tool on Oracle, DB2. XML, SQL and flat files.
• Experienced in Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Possess strong data warehouse applications knowledge
• Possess experience with data migration initiatives and data warehouse concepts (cubes, star schemas, etc.), and experience with front - end web technologies (HTML, Confidential, JavaScript)
• Possess knowledge and experience of working with relational databases and SQL
• Possess expert-level SQL coding/querying skills in Oracle

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center , Data Stage, SSIS

Business Intelligence: Crystal Reports XI and XIR2

Databases: Oracle , MS Access

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

Web Design: Dreamweaver , Flash

Oracle Tools: TOAD, SQL Developer, SQL Navigator, SQL*Loader, SQL*PLUS

Office Tools: MS OFFICE 2000

Webservices: SOAP UI,Webservice Hub(WSH), Informatica

Software Lifecycle Management Methods: Scrum, Agile, Spiral, and Traditional Waterfall model.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update,
• Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.

Confidential

ETL Developer

Responsiblities:

• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
• Develop key integrations with both internal and external systems
• Collaborate with team members to prototype, test, and debug code which will provide data for use in business reports
• ETL development, testing, implementation, and support of integration solutions
• Support ETL and Data Warehouse production, development & test environments
• Conversion/Migration of data into new systems
• Data analysis, data mapping, data loading, and data validation
• Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
• Worked with Mapping and Workflow variables by using the value of mapping variables on the workflow level.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
• Responsible to tune ETL mappings to optimize load and query Performance
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
• Worked on Shell Scripts in order to convert incoming Excel Flat files from .xls to .csv which helps importing into Informatica.

Environment: SQL, PL/SQL, HP Quality Center, Java XML, Oracle, PostgreSQL, Informatica, Business Objects, TOAD for Oracle

Confidential, Jacksonville, FL

ETL Developer

Responsibilities:

• Understanding the functional specifications and the documents related to the Architecture.
• Understanding legacy systems data and building, designing Target DB schema.
• Identified suitable dimensions and facts for schema.
• Helped users in building the scenarios.
• Worked on Extraction, Transformation and Loading of data using Informatica.
• Experienced in Informatica data quality (IDQ), power center, data cleansing, data profiling, data quality measurement and data validation processing.
• Developing several complex mappings in Informatica a variety of Power center transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Performed profiling, matching, cleansing, parsing and redacting data using Informatica IDQ and implementing standards and guidelines
• Used GSK application to setup the group and subscriber data in the FACETS application.
• Participated in regular discussions with the Facets team to enter test data.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Performed profiling, matching, cleansing, parsing and redacting data using Informatica IDQ and implementing standards and guidelines.

Environment: Informatica Power Center 8.6, Informatica Data Quality (IDQ), Toad, Teradata,Oracle 11g, PL/SQL, RDBMS, Facets 4.51, Unix Shell Programming, Control-M.

Confidential

ETL Developer

Responsibilities:

• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Part of the Informatica upgrade project which was from version 7.0 to 9.0.
• Testing and Redesigning the existing Informatica mapping/workflows as a part of upgrade.
• Scheduling the Informatica and other related processes using MAESTRO schedulers and BEE(Nationwide own).
• Modifying the UNIX scripts as a part of Upgrade and making sure they point to the correct directories.
• Modifying table structure according to the new/changing requirement and also interacting with business users and DBA in order to be on the same page.
• Working closely with the testers in order to help with overall-testing completion of the commited Iteration capacity(points).

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10g, TOAD, SQL Developer, AQT, UNIX Shell Scripts.