SUMMARY

• 7 years of strong experience as an Informatica (ETL) Developer in System Analysis, Design, Development and Testing fields of Data Warehousing, Client server technologies.
• Strong experience in integration of various data sources like Oracle, Teradata, MS SQL Server, DB2, Mainframe and Flat Files.
• Proficient in warehouse designs based on Ralph Kimball and Bill Inman methodologies.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Extensively used Informatica tools, Designer, Server Manager/Workflow Manager, Work flow Monitor, Repository Manager.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Union Transformation.
• Highly experienced in developing mappings using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
• Proficient in developing Slowly Changing Dimension Mappings of type I, II and type III.
• Expert in loading data in to Teradata using FASTLOAD, MLOAD, TPUMP, BTEQ and Teradata Parallel Transporter (TPT) tools.
• Extensively played with Performance Tuning at Informatica and Database (Oracle) Level.
• Excellent hands on experience in writing, testing and implementation of the PL/SQL programs, Stored procedures, Functions, Triggers, Views, Materialized Views, Packages, DTS and performance tuning of SQL queries.
• Strong experiences in UNIX shell scripting. Created scripts for calling pmcmd command, file watcher, FTP and file archiving scripts
• Strong practical understanding of Star Schema and Snowflake Schema Methodology, using Data Modeling tool Erwin 4.0/4.2.
• Extensive experience in Unit testing, System testing and User Acceptance Testing.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

• Informatica PowerCenter 9.1/8.6/8.1/7.1/6. x (Source Analyzer
• Data Warehouse Designer
• Mapping Designer
• Mapplet
• Transformations
• Workflow Monitor
• Worklets)
• Power Exchange 8.x
• Business Objects XI
• Jasper PRO 4.2
• Data Modeling Tools Erwin 7.0/4.1/5.1
• Composite 6/5
• Autosys r11
• OBIEE 10g
• Oracle PL/SQL
• SQL Plus
• T - SQL
• SQL Server DTS
• DB2
• Korn Shell Scripts
• Oracle 7.x/8i/9i/10g/11g
• MS SQL Server 2000/2005/2008
• Teradata V2R5/V2R6
• DB2 8.1
• MYSQL
• C
• C++
• JAVA
• HTML
• XML
• QC 10
• OS Sun Solaris 8/9/10
• Linux
• IBM AIX 4.3/5.2
• Cybermation Espresso
• Packages SQL* PLUS
• Toad 9.7/8.6.

PROFESSIONAL EXPERIENCE

Confidential, MCKINNEY, TX

INFORMATICA DEVELOPER

Responsibilities:

• Involved in meeting with business to gather requirements.
• Reviewing data models and doing code reviews.
• Creating complex stored procedures, functions, triggers and packages.
• Creates and maintains the overall and detailed project plan(s) and supervise the D/W ETL processes.
• Using the Informatica Designer to develop mappings and workflows for extracting, transforming, integrating, and loading data to data warehouse.
• Using Expression, Lookup, Normalizer and Aggregator Transformations in designer to achieve complex business logic.
• Using Key Management functions Surrogate Keys were generated for composite attributes while loading the data into Data Warehouse.
• UNIX Shell Scripts for automating Extraction, Transformation and Loading process for various feeds and enabling the execution of jobs in Production environment using Autosys.
• Designed and developed monthly reports using Oracle Reports for the analysis of the data
• Involved in development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Used Data validation Test, SQL views using Informatica DVO Utility for Business analysts to perform UAT on source database upgrade for Well Dimensional Team data, source database.
• Designed and developed Meta Data structure to capture the source and target tables count and created test data from legacy existing system through SP for testing purpose.
• Created column level mapping from existing legacy system application to new developed system.
• Developed Test plans for testing purpose to cover each and every scenario with Business logic for UT.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server, & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
• Used Toad Data point for testing source and staging tables.
• Developed Store procedures to load Dimensional tables with in same DB.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Confidential, ATLANTA, GA

INFORMATICA Developer/Data analyst

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server, DB2, Teradata & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges using Informatica Repository Manager.
• Was responsible for the version control and up-gradation.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers and Stored Procedures in the server side.
• Involved in creation of Classes, Objects and Universes for reporting purpose using Business Objects Designer.
• Wrote UNIX Shell Scripts and pmcmd command line utility for automating Batches and Sessions using ESP Workload manager.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 9.0.1/Informatica Power Center 8.6.1, Erwin 7.1, MS SQL server 2005/2008, Oracle 10g/9i, DB2, SAP R/3 databases, XML, SQL, PL/SQL, Shell Scripts, Windows XP, Unix, Espresso (ESP) Workload Manager, Business Objects.

Confidential, Norwalk, CT

INFORMATICA/TERADATA Developer

Responsibilities:

• Requirement gathering from the end users and preparation of the BRDs.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
• Developed Re usable Transformations, and Re Usable Mapplets
• Transferred data using Teradata utilities like Teradata Parallel Transporter (TPT), BTEQ, Fast Export and Fast Load
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Extensive experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Worked with third party CA Autosys scheduling Team for scheduling the Informatica Power Center Workflows.

Confidential

ETL / Informatica Developer

Responsibilities:

• Involved in every step of the SDLC. Involved in customer requirements, Data analysis, process flow design, data modeling for atomic and Data mart.
• Helped Architect in design and development of Conceptual, Logical, and Dimensional Data Models for the Data Warehouse.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Developed the process flow for the project and created the data model for Atomic and Data mart based on the customer requirements.
• Involved in assisting the team to develop the mappings and execute.
• As the requirement is to maintain the history of every change for all columns, I have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Designed and coded the Espresso job flow, which is for job scheduling.
• Involved in project planning and coordinating business, source and development teams to meet the project deadlines.
• Data analysis is done to see the impacts of change in source system to the existing Informatica maps, Oracle PL/SQL packages to feed data into existing Datamart.
• Formulated the business rules for changes identified in the analysis and modified Informatica maps, PL/SQL packages and Espresso flow to handle the load time of each regular cycle run.
• Key person in working for system performance improvement for the datamart loading and reporting.
• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.