SUMMARY

• 7 years of work experience in software development and support with focus on ETL Data Warehousing and Business Intelligence solutions.
• 5 years of experience in working with ETL tool Informatica PowerCenter (Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager).
• 1 year of experience in working with ETL tool IBM Data Stage.
• In depth knowledge of data warehouse architecture and designing star schema, snowflake schema, Fact and Dimensional Tables, Physical and Logical Data modeling using Erwin.
• Experience in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).
• Experienced in Data analysis, Data modeling concepts, Database design and Data migration.
• Expertise in writing complex SQL in various databases like Oracle and SQL Server using them as source and target systems.
• Expert in working on various operating systems like UNIX and Windows and extensive experience in UNIX Shell Scripting.
• Expertise in scheduling tools like Autosys.
• Proficiency in understanding the Business requirements and translating them into detailed design along with Technical specifications.
• Quick learner, highly motivated, result oriented and an enthusiastic team player who is always open to new challenges and technologies.
• Experienced at Creating effective test data and development thorough Unit test cases to ensure successful execution of the data.
• Excellent communication and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5, Data stage

Scheduling Tools: Autosys, ESP job scheduler

Reporting Tools: Business Objects - basics, Crystal Reports

Databases: Oracle 11g, SQL Server 2008

Operating Systems: UNIX (AIX), Windows

Languages: SQL, PL/SQL, UNIX Shell scripting

Web Technologies: HTML, XML

Tools: and Utilities: Toad, Putty, VSS, SVN

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Informatica - ETL Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.

Environment: Informatica Power Center 9.5, Oracle 11g, Tableau, Linux

Confidential, Cleveland OH

ETL Developer

Responsibilities:

• Designed and developed complex ETL's using various transformations like Source Qualifier, Unconnected and Connected lookups on Oracle Tables, Unconnected lookup on Flat Files, Normalizer, Union, Router, Filter, Expression, Aggregator, Sorter, Joiner, Web Service Consumer Transformation, and Update Strategy.
• Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet all the complex business rules implemented in ETL mappings.
• Developed stored procedures and calling them into Stored Procedure transformation to create the sequence in Data warehouse and Data Mart Tables.
• Documentation of ETL Mapping Specifications.
• Analyzing the data feeds (through Flat File & COBOL Sources) by working with Mainframe Team
• Followed the quality code standards described by the client.

Environment: Informatica 9.1, Congo’s 8.0, Oracle 11G, SQL, PL/SQL, AIX- UNIX.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Worked on the business requirements and functional specifications with business team.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Created complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Worked on data extraction from oracle database and spreadsheets and staged into a single place.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Documented program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Developed stored procedures and functions to handle various activities outside of Informatica ETL process. Created Functions & Procedures for the ETL process and for Data Validations between source and target tables.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.

Environment: Informatica 8.6, Cognos 8, SQL, PL/SQL, DB2, UNIX, Enterprise Manager.

Confidential, Warren, NJ

ETL / Data stage Developer

Responsibilities:

• Understand the Technical specifications and Mapping Data Items from Source System to the Target System.
• Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Created various local containers and shared containers.
• Developed jobs using various stages-Transformer Stage, column generator Stage, Filter Stage and Sequential File Stage.
• Designed and developed jobs using Parallel Extender for splitting bulk data in to subsets and to dynamically distribute to all available nodes to achieve best job performance.
• Used Data Stage Designer to extract, cleanse, transform, integrate, and load data into the DataMart.
• Developed Data Stage Parallel jobs and Shared Containers using Lookup, JOIN, Copy, Change Capture, Aggregator, Column Export, Column Import, Remove Duplicates, Dataset, Transformer, Lookup File Set, Filter, and Funnel Stages.
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the job performance.

Environment: IBM Info Sphere Data Stage, Oracle, Unix, MS Office, Visio, PL/SQL, SQL Server, Toad.

Confidential

Oracle Trainee/ Developer

Responsibilities:

• Involved in the creation of database objects like tables, views, packages, procedures
• Involved in data gathering and system functionality requirements study
• Developing Oracle PL/SQL stored procedures, Functions, SQL scripts to facilitate the functionality for various modules
• Developed PL/SQL Procedures, Functions and used SQL loader to load data into the database
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, created DDL scripts; Created database objects like Tables, Views and Indexes.

Environment: Oracle, SQL, PL/SQL, Windows and UNIX.