SUMMARY

• Eight years of IT experience in Data warehousing, Data Analysis and Data Migration, Development, ETL, Maintenance, Unit Testing and Documentation in diversified industries like Electronics, Automobiles.
• Data Warehouse experience using Informatica Power Center 8.x/9.x (Source Analyzer, Repository Manager, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Manager, Monitor) as ETL tool
• Experience on IDQ Workbench IDQ Developer and address doctor for data quality and integrity checks.
• Extensively used Oracle and Microsoft SQL Server
• Having exposure to DB2, Salesforce as source in Informatica mapping
• Have exposure to Workday. Created source files to be uploaded in Workday
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, Deployment, Maintenance and Production support
• Knowledge of Dimensional data modeling, Star schema modeling, Snowflake modeling, with experience in TOAD and SQL Developer
• Knowledge of end to end Data Migration projects, the approach, the dependencies and flow
• Interacted with SAP environment using LSMWs and IDOCs during Data Migration
• Have knowledge of SAP FICO object like - Assets and worked on loading data for Stocks, Material Master, Include exclude in SAP during data migration
• Experience in creating Transformations (Lookup, Joiner, Aggregator, Expression, Update Strategy, Router, Filter, Normalizer, Transaction control, Source Qualifier, Sequence Generator, Sorter and Rank), Mappings using Informatica Designer and Tasks (Sessions, Command, Email) using Workflow Manager to move data from multiple sources into targets
• Created reusable Worklets and Mapplets
• Extensively Implemented Error Handling techniques
• Experience in the SDLC (Software development Life Cycle Process) especially with the Waterfall model and Agile method
• Experience in converting business requirements into High Level Design, Detailed Designs and converting them into ETL code
• Have worked on various ongoing maintenance issues and bug fixes, monitoring Informatica sessions.
• Experience in creating Parameters and Variables.
• Well versed in OLTP and OLAP Data Modeling, Data warehousing concepts
• Have worked with Reporting team to solve the data issues
• Ability to coordinate the flow of development initiatives, Design, Development and all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills
• Organized, Motivated, flexible and a quick learner with the ability to multi-task and work independently or in a team environment
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent communication and interpersonal skills
• Versatile team player with proven problem solving skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x, 9.x

Databases: Oracle 10g, Microsoft SQL Server 2005

Languages: SQL, Unix Shell Scripting, PL/SQL

Development Tools: Toad, SQL Developer 2000

Operating System: Windows 2000/XP/2007, Microsoft Windows Server 2005, Unix

Office Applications: MS-Office 2000/2003/2007 , MS-Visio

Other Utilities: LSMW/IDOCs in SAP, Citrix XenApp, ALM(Defect tracking), IDQ Workbench, IDQ Developer, address doctor

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Informatica Developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for the project that involved data migration from legacy to Workday
• Developed ETL Informatica mapping in order to load data into staging area. Extracted data from flat files and loaded the same into Oracle 10g target database generated target files as output
• Have performed a data quality check (length, format), address check with address doctor on the source extract before the transformation.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews before moving the code into QA.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.

Environment: Informatica Power Center 9.1 Designer, Work Flow Manager, Monitor, Oracle 10g/Toad/SQL Developer, Unix Shell Scripting

Confidential, Nashville, TN

Responsibilities:

• Involved in the Design, Analysis and Development of data mart using Informatica Power Center tools
• The project involved creating data mart used for reporting purpose
• Designed and developed complex Informatica mappings including Type-II slowly changing dimensions
• Worked extensively on different types of transformations like Source Qualifier, Aggregator, Joiner, Lookup, and Sequence Generator, Expression, Normalizer, Filter transformations
• Designed incremental loading process to load data into staging tables
• Involved in preparation of technical design document along with vision diagrams for ETL
• Performed Unit Testing for all developed ETL mappings
• Widely used Shared folders, project folders (Non-Shared folders) and short cuts to maintain integrity between Development, Test, Data validation and Performance
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Hands on experience in Unix shell scripting

Environment: Informatica Power Center 9.1 Designer, Work Flow Manager, Monitor, Oracle 10g/Toad/SQL Developer, Unix Shell Scripting

Confidential, Andover, MA

Informatica ETL Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document
• Responsible for development, support, maintenance and implementation of small to medium non- complex components of a project module
• Developed ETL Informatica mapping in order to load data into staging area. Extracted data from flat files and loaded the same into Oracle 10g target database generated target files as output
• Have exposure to Workday, the format and look and feel
• Designed Mapping document used as guideline to ETL Coding
• Used mapping Parameters and Variables
• Have used FTP connection as source and target in Informatica
• Implemented a proper Error Handling design in the ETL Code, generating a detail Error File
• Analyzed Session log files to resolve errors in mapping and managed session configuration
• Responsible for development, debugging, unit testing of several iLoads in this project
• Responsible for transforming employee HR data of Confidential globally. The objects owned were - Positions, Applicants, Hire, Employee Addresses, Employee Names, Employee Phone Numbers, and Service Dates
• Worked as an individual team member to develop most of the process as well as working in a team to co-ordinate with other team members

Environment: Informatica Power Center 9.1 Designer, Work Flow Manager, Monitor, Oracle 10g/Toad

Confidential -Charlotte, NC

Informatica ETL Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document
• Responsible for migration of some vital objects like Material, Assets, Stocks, Include Exclude, Packing Instruction from legacy system into SAP
• Have fetched data from SAP R/3 in Informatica. Exposure to the procedure of connecting to SAP with Informatica
• Have used IDQ workbench for data quality checks on the given source
• Transformed the given JDE extract of each object as desired and loaded it into SAP
• Prepared the Load Reports after migrating the data into SAP, thereby tracking the source, target and errors in detail
• Responsible for validation of the data loaded into SAP
• Have developed mappings to automate the generation of Load Reports
• Worked on end-to-end Data migration process, with Data Quality check, data transformation and data upload along with the detailed Load Report
• Worked on LSMWs and IDOCs that’s loads data into SAP.
• Have fetched data from SAP into databases from Informatica
• Creating Test Cases, Unit Testing and Integration Testing to ensure the successful execution of data load
• Have used ALM for Defect tracking
• Have provide 24*7 support during Production rollover.
• This involved global data migration of Confidential .
• Responsible for all the technical documents for each object owned.
• Hands on experience in Informatica Data Quality to analyze, standardize and cleanse the data

Environment: Informatica Power Center 8.0 Designer, IDQ Workbench, Work Flow Manager/Monitor, SAP, Microsoft SQL Server 2005, Windows Server 2005, Windows 2007, Citrix XenApp

Confidential - Franklin, TN

Informatica ETL Developer

Responsibilities:

• Extracted Data from File as a Source by using Informatica and populated into staging area to cleanse and apply business rules for transformation of the data
• The target tables populated was further used by the Reporting team
• Designed and developed Aggregate, expression, filter, join, Router, Lookup and Update transformation rules
• Developed several reusable transformations and mapplets that were used in other mappings
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic
• Enabled the version control in DEV environment to determine the changes in the folders and copied them to TEST environment
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email
• Involved in Unit Testing for the validity of the data from different data sources

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/Toad, Windows2000

Confidential 

Responsibilities:

• Developed ETL mappings, transformations using Informatica power center.
• Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/Toad, Windows2000