SUMMARY:

• Over 7+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center across various industries such as IT industry, Telecom, Automobile and Confidential .
• Hands on experience in Extensive Data Warehousing using Informatica PowerCenter 9.6.1/9.1, 8.6/7.1 and Relational databases like Oracle 11g/10g and Data Warehouse Appliance with expertise in complete life cycle implementation of data warehousing.
• Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate - wide-ETL solution using Informatica Power Center.
• Scheduled and Monitored Informatica/Unix jobs using, ESP, Maestro and Informatica built-in schedulers.
• Well versed with the Database and Data Warehouse concepts such as dimensional data modeling, OLTP, OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling, Views, Physical and Logical models, Analytical functions, Stored Procedures, Functions and Triggers.
• Experienced in Normalization & Demoralization processes, Logical & Physical data modeling techniques.
• Optimized the Solution using various performance-tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Indexes, partitioning, Materialized Views, Procedures and functions).
• Programming skills using PL/SQL, MySQL, and Shell Scripts.
• Created scripts for collection of statistics, reorganization of tables and indexes.
• Created indexes for efficiency and performance.
• Worked on Slowly Changing Dimensions (SCD's) Types -1, 2 and 3 to Tracked historical data.
• Thorough knowledge in developing Stored Procedures, Views and Functions.
• Proficient in analyzing business requirements, establishing functional specifications and translating them to design specifications.
• Experience in performing and supporting Unit testing, Acceptance Testing, System Integration testing (SIT), UAT and production support for issues raised by business users.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Unit testing and Integration test of the ETL code with test cases.
• Proficient in Oracle, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6.1/9.1/8.6.1/7.1.2 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Informatica Data Quality IDQ, SQL Server SSIS

Data Modeling methodology: Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, DB2 UDB, MS Access 2000, Sybase

Others: Toad, SQL Navigator, Teradata SQL Assistant

Environment: MS Windows 2008/2005, UNIX, Linux

Job Scheduling: Autosys, Tidal

SDLC: Waterfall, Agile, TD

Reporting Tools: Micro strategy, Excel, ProClarity

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling.
• Managed migration in a multi-vendor supported Server and Database environments.
• Developed ETL mappings to create XML files from MQ Series and load into MQ queue.
• Developed ETL mappings to load into DB2 dabase tables using COBOL files and flat files as source.
• Developed shell scripts to automate balance, archive and metrics of Transactions.
• Created job sets, jobs along with predecessors and scheduled jobs to load data daily using Control M scheduling tool.
• Wrote UNIX Shell scripts to schedule jobs.
• Identified gaps in business requirements to Informatica workflows, debugged missed information in the XML files, and worked with Source System team to analyze missing information. Documented the workflows, ETL designs, test cases and mentor the new team members.
• Fine-tuned existing Informatica maps for performance optimization.
• Used SQL tools like SQL Developer and DB2 Data Studio to run SQL queries and validate the data. Tuning the Mappings for Optimum Performance.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Prepared applicable process flow diagrams and run documents to help production services in daily runs.

Environment: Informatica Power Center, Oracle 10g, DB2, UNIX, SQL, DB2 Data Studio, SQL Developer, XML files, MQSeries.

Confidential, Baltimore, MD

Informatica Developer

Responsibilities:

• Responsible for the development and support of ETL mappings utilizing Informatica Power Center as the ETL development environment built upon Oracle 10g RDBMS.
• Gathered requirements and converting those business requirements into ETL specifications.
• Conducted and participated in code reviews.
• Created project plans for development of MicroStrategy projects.
• Provided enhancement to the existing ETL code and developing the logic based on desired functionality.
• Responsible for optimizing ETL processes including Informatica sessions and mappings.
• Created Technical Documentation and also maintaining them, created ETL standards document for the developers to follow.
• Worked with Data Architecture direction team and data development team leads to create guidance, standards, and processes for use of data within the various data disciplines.
• Participated in the design and implementation of new or changing mappings and workflows to produce requisite specifications.
• Used Star-Schema Data Warehouse design technique.
• Involved in extracting the data from the flat files and load the data into ODS and Data Mart.
• Created Oracle PL/SQL Packages to implement functional Requirements.
• Wrote UNIX Shell scripts to schedule jobs.
• Provide timely project status and escalate issues appropriately.
• Make sure efficient Error Handling methodology throughout the mappings are designed and implemented.
• Provide tactical solutions to bridge implementation gaps and phased implementation of systems.
• Interacted with Cognos Developers to help them understand the logic and improve reporting.
• Designed various prototypes of dashboards using Microstrategy, which would give ability to the users to drill down to claim (lowest) level.
• Created Teradata SQL scripts for Clean up.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Environment: Informatica Power Center 9.1/8.5.1, Oracle 10g, SQL Plus, TOAD, SQL Developer, Windows XP, UNIX.

Confidential, Cleveland, OH

Informatica Developer

Responsibilities:

• Assisted on appropriate Extraction, Transformation and Loading strategies for optimization outside of daily project work.
• Used the Extract Transform & Load tool, Informatica, to move information from multiple source systems to the Operational Data Store (ODS).
• Performed data quality assurance tests, created flat-file dumps.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, and shell scripts.
• Designed Connected and Unconnected lookup transformations to perform lookups on related data.
• Used Aggregate Transformation, Expression Transformation, Filter Transformation, Lookup Transformation, Joiner Transformation, Sequence Generator Transformation, Stored Procedure Transformation, Update strategy Transformation, Rank Transformation.
• Used SQL and transformation language commands in Filter and Expression transformations.
• Analyzed the Sources and Targets and designed complex mappings and Transformations.
• Involved in trouble shooting of performances issues with the SQL statements and Informatica Sessions in terms of reducing the data transfer time.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.
• Interact with business analysts and translate business requirements into technical specifications.
• Developed the SQL queries for the source system.
• Performed thorough data analysis and mapping of data elements from various source systems to multiple targets.
• Created Batches, scheduled them and monitored the sessions for loading data into the data warehouse.

Environment: Informatica, Unix, MS Excel, Oracle, PL/SQL, SQL Server 2008, Windows NT.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Involved in translating business requirements to integrate into existing data mart design.
• Created complex mappings to read multiple sources and write to multiple targets.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Bourne Shell Scripts for Daily, Weekly and Monthly Jobs which are used for Downloading/Placing Source and Target Files to/From Different Servers.
• Responsible for creating and maintaining Informatics processes, mentoring junior Informatica developers, managing data warehouse schemas, assisting with SQL tuning techniques, creating views, tables, snapshots to assist report teams.
• Worked on Stored Procedures in fixing the bugs, modifying the PL/SQL code for Small Enhancements.
• Managed multiple tasks and responsibilities in high-pressure implementations.
• Migrated mappings, workflows from one environment to another environment.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Experience in working on change requests which includes creating changes (Data Repair, Low Impact, Major and Minor Change requests), implementing the Changes.
• Extensively used Informatica to load data from Sequel Server and flat files into staging area.
• Developed Shell Scripts for triggering Informatica Workflows using PMCMD Command.
• Worked as first on call Production Support for Existing Applications.
• Worked in Scheduling daily, weekly and Monthly jobs using Control M to extract information from multiple data sources and provide Target Files to Business Users.

Environment: Informatica, Oracle, SQL Server 2008, Teradata, TOAD, UNIX, Autosys, MS Visio.

Confidential

ETL Developer

Responsibilities:

• Interact with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target, star Schema on oracle 8i instance.
• Used source Analyzer and Warehouse designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Involved in designing informatica architecture, naming standards for folders/ transformations/ mappings/ sessions across the repository.
• Implemented mapping changes in compliance with the requirement of the change management process.
• Created shared folders, local and global shortcuts. Develop data transfer strategy to extract and integrate data from ORACLE, EXCEL FILES, MS SQL SERVER and Teradata into data warehouse.
• Developed complex mappings/sessions using Informatica power center for data loading.
• Setup Jobs in the database to analyze main schemas on a regular basis in order to have correct stats for Oracle optimizer.
• Optimized SQL queries using EXPLAIN PLAN and ANALYZE.
• Scheduled and Run Extraction and Load process and monitor workflows using workflow monitor
• Development of ETL mapping and Reports along with Unit Test, Integration Testing.
• Developed the control files to load various sales data into the system via SQL Loader.

Environment: Informatica, Oracle, Toad, BO, Shell scripts