SUMMARY

• Over 7 years of experience in IT industry in the design, development, implementation, testing and maintenance in Data Warehouse and Client Server environments.
• 5+ years of ETL Data warehousing experience using Informatica Power center 9.x/7.x(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations Designer Repository Manager, Workflow Manager and Workflow Monitor).
• Experience in developing Informatica mappings, mapplets, sessions, workflows.
• Worked on tuning of Informatica mappings/sessions.
• Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and loading of data from multiple sources to Data Warehouse.
• Experience in developing Unix Scripts.
• Worked with every phase of Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Strong working experience in the Data Analysis, Design, Development, Implementation and testing of Data Warehousing using ETL tool Informatica power center.
• Excellent Working Knowledge on multiple Platforms like HP - UX, Windows 7 / XP
• Worked with heterogeneous databases like Oracle, DB2, SQL Server, MS-Access etc
• Good Experience with Business Users to analyze the business process and make necessary changes to schema objects to scatter their BI needs.
• Good communication and inter personal skills.

TECHNICAL SKILLS

Operating Systems: Windows XP, HP-UNIX

Languages: SQL

Databases: DB2, MS-Access, Oracle, SQL, TOAD

Domain Knowledge: Health Insurance, Transport, Communications

ETL: Informatica Power Center

BI: Business Objects, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

ETL Developer

Responsibilities:

• Involved in analyzing the source data coming from different data sources such as Flat files, oracle and SQL Server and identifying data anomalies in operational data
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager
• Used all the transformations like Filter, Joiner, Expression, Aggregator, Router, Rank, Lookup and Update Strategy transformations
• Implemented depending on required dimension tables. Type 1, Type 2, Type 3 slowly changing dimension
• Used Parameter files to define values for parameters and variables used in mappings, sessions, worklet or workflow.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle,DB2,SQL server and Flat files into the target EDW.
• Created Error handling strategy for trapping errors in a mapping and sending errors to an error table
• Used Debugger to validate mappings and also for gaining troubleshooting information about data by inserting breakpoints.
• Developed fine tuned Transformations, Mappings and Mapplets between source systems and warehouse components
• Worked on code Migration Strategies between Development, Test and Production repositories
• Created and scheduled Workflows using Informatica workflow manager.
• Coordinated tasks and issues with team lead and project manager on daily basis
• Prepared Unit test documents, which captures the test conditions and scripts, expected/actual results and data cross-section and volume for Individual interfaces components
• Was responsible to support related activities during warranty period.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards.

Environment: Informatica Power Center 9, Oracle, Flat files, DB2/400,TOAD, MS SQL SERVER 7.0/2000, Windows XP, HP-Unix.

Confidential, Irving TX

ETL Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BI database.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and developing ETL solutions in Informatica Power Center 8.1
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given SLA.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Expertise in creating control files to define job dependencies and for scheduling using Informatica.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.

Confidential, IL

Informatica Developer/ QA Tester

Responsibilities:

• Workedwith Business users to collect requirements and prepared ETL technical specifications.
• Performance tuned various mappings, Sources, Targets and transformations by optimizing caches for lookup, joiner, rank, aggregator, sorter transformation and tuned performance of Informatica session for data files by increasing buffer block size, data cache size, sequence buffer length and used optimized target based commit interval and Pipeline partitioning to speed up mapping execution time.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created reusable transformations and Mapplets in the designer using transformation developer and Mapplets designer tools.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Documented handbook of standards for Informatica code development.
• Validating the data using SQL in Toad and BO Reports in Desktop intelligence
• Performed Unit, Security, Functional, and Regression Testing
• Validating the Objects created in the Universe and checking security roles to it.

Environment: Informatica Power Center 7.1.5, Oracle 10G, Toad 9.6.1, Unix, BO XI Release2.