SUMMARY:

• Over 8+ Years of experience in Software Development Life Cycle (SDLC) with in Design, Coding, Testing, Development & Implementation of Data Warehouse/Data Mart under Unix & Windows Environments.
• Extensive experience with Informatica PowerCenter 9.0.1/8.6.1 . Advanced knowledge and excellent concepts in development and design of ETL methodology for supporting data transformations and processing ETL solutions.
• Experience with IDQ Data Developer and Data Analyst tool installation & configuration.
• Comprehensive knowledge in implementation of Data Warehousing,Dimensional Modeling on OLTP and OLAP concepts 
• Extensive experience in integrating data from various sources like Relational database (Oracle 11g/10g, SQL Server 2008), Flat Files (Fixed Width and Delimited), XML Files and Excel files into Data Warehouse and Data Mart.

TECHNICAL SKILLS

ETLTools: Informatica Power Center 9.0.1/8.6.1

Databases: Oracle 11g/10g/9i/8i, SQL server 2008, Netezza

RDBMS Tools: TOAD, SQL Developer, SQL Plus, MS SQL Management Studio

Reporting Tools: Crystal Reports, Universe

Scripting: Unix shell scripting

Other Tools: ERWIN 4.2/4.0/3.5.2 Control - M, Autosys, TIDAL, Secure FTP(SSH), MS Excel, Notepad++

EXPERIENCE

Oracle Developer

Responsibilities:

• Created the Interface with Visual Basic and connect Oracle Database through connection string.
• Interact with various business users of VCMG in order to understand concept and Business Logic.
• Involved in creation of Tables using storage parameters and clusters
• Coded many generic routines (as functions), which could be called from other procedures
• Created user defined Exceptions while handling exceptions
• Wrote the Connection String procedure for the Database connectivity using ODBC
• Wrote stored procedures, Functions and Database triggers using PL/SQL
• Take the backup of server using import/export command

Environment: Oracle 9i, PL/SQL, SQL*Plus, Excel, Word, Windows2003 and Visual Basic 6.0

Sr. ETL Developer

Responsibilities:

• Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment, and provided production support, Captured requirements from the Business Analysis Team, designed Test Plan, Test Strategy, Test scenarios and executed in Development/ QA/ Performance environment.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
• Extract the data from relational source Oracle, flat files and perform mappings based on company requirements and load into Oracle tables. Used lookup transformation (Static as well as Dynamic), aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Extensively used Re-usable Objects (shortcuts) like Sources, Targets in all mappings to handle metadata changes efficiently
• Also used Used-defined Function, which declared once globally and used in various mappings.
• Creating Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Have developed IDQ plans to standardize & de-duplicate data. Used IDE extensively during application migration.

Environment: Informatica Power Center 9.0.1, Oracle 11g, Salesforce, TOAD, XML Files, Windows, Mac, Unix, SSH Client.

Sr. ETL Developer

Responsibilities:

• Interacting and coordinating with System architects, Business executives, analysts, Data population engineers and developers.
• Analyzing the Functional requirements and Technical requirements, preparing technical design documents, HLD and LLD for mappings and automating the daily flow.
• Syncing the data model with concurrent changes.
• Used Informatica Power Center 8.6.1, to developed Mappings/Sessions/Workflows.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected and unconnected Lookups, Update Strategy, Stored Procedure, Router and Normalizer to transform and load the data from different data sources to relational tables.
• Implementing performance tuning the Informatica objects to increase the Performance of the Informatica loads. Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance, used Informatica Partitioning.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Worked on database connections, views, aggregate conditions and also wrote various PL/SQL procedures, Functions and Triggers. Performance tuning of SQL.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql Queries
• Actively involved in migrating the Informatica version, interacted with DBA, Middleware, Informatica administrators and UNIX/Linux administrators to identify and analyze the impact/risk on the upstream/downstream systems.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, TOAD, Flat Files, Windows XP, Unix.

Senior ETL Developer

Responsibilities:

• Analysis in Business requirements and created design specifications and developed the code using Informatica power center 8.6.1 and Oracle 11g.
• Developed the code for customer Tables, sales Tables Using Informatica Power Center Client components.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Used Parameter Files defining variable values for mapping parameters and variables.
• Used Informatica Functions like REPLACECHR, UPPER, DECODE, TRIM, FIRST, DECODE Functions in Transformation level.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Improved performance testing in Mapping and the session level.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Documented Data Mappings/ Transformations as per the business requirement.
• Created XML,Autosys JIL for the developed workflows.
• Extensively involved in code deployment from Dev to Testing.

Environment: Informatica Power Center 8.6.1/9.0.1 , Oracle 11g, TOAD, Flat Files, SAP, Windows, Unix

ETL Developer

Responsibilities:

• Worked with heterogeneous sources including relational sources and flat files.
• Worked with Data Modeler and Data Architect to understand the Architecture of Data warehouse and the mapping Documents.
• Design mappings based upon the complex business logic provided by data modeler, which includes Dimensions and Fact Tables.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
• Extract the data from relational source Oracle, flat files and perform mappings based on company requirements and load into Oracle tables.
• Used lookup transformation (Static as well as Dynamic), aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Extensively used Re-usable Objects (shortcuts) like Sources, Targets in all mappings to handle metadata changes efficiently
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Ensure smooth transition of work to offshore team. Transfer ETL requirements and ensure timely completion of deliverables with offshore.
• Also used Used-defined Function, which declared once globally and used in various mappings.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc
• Used EXPLAIN Table plans to tune the SQL Quires
• Automated the load process using UNIX shell scripts
• Create Mapping that Generate Parameter file and load log.
• Used Autosys to schedule the workflow.
• Experience in creating reports using Business Objects.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process
• Interact with various business users of VCMG in order to understand concept and Business Logic.

Environment: Informatica Power Center 8.6, Oracle 10g, TOAD, Flat files, Linux, Windows XP, Autosys, Business Objects.