SUMMARY:

• Having around 8+ years of experience in IT industry as Software Engineer; Working as a Senior BI Consultant in Confidential Partners from Oct .
• Having good experience in IT industry, experience in Data warehousing and has been extensively involved in Development.
• Experience in Data warehousing ETL tools like Informatica Power Center 8.x/9.x.
• Developed Parameter file generation mapping.
• Developed Audit statics mapping for capturing source and target counts and failure status.
• Created Connection strings in Informatica level.
• Involved prepared Review check list as per coding standards.
• Involved code migration from DEV to higher environments.
• Involved Error Handling, capturing error records loading into Exception table
• Developed SCD TYPE1 and TYPE2 mapping.
• Good knowledge about Debugging for Informatica mappings
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies and Knowledge in programming with SQL, PL/SQL.
• Extensively used ETL methodology for Data Extraction, transformation and loading processing.
• Experienced in performance tuning of mappings, sessions, workflows and designed mappings according to business requirements by using different transformation in Informatica like Lookup, Joiner, Aggregator, Router transformations etc
• Good at developing SQL and PL/SQL codes through various procedures, functions.
• Good knowledge on Unix.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Good interpersonal skills, result oriented hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS:

ETL Tool: Informatica 8.x/9.x .

Database: Oracle 10g, 11g, DB2

Programming Languages: Sql, PL/SQL, Shell script .

Development tool: Toad, SQL developer .

Third Party Tool: DAC

Operating Systems: Windows 98/NT, AIX and HP UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI Developer

Environment: Informatica 9.6, Oracle 11g, Windows XP, UNIX

Responsibilities:

• Understanding the client’s business functionality
• Involved in understanding the sources, targets, transformed the data, mapped the data and loading the data into targets using Informatica
• Developed Parameter file generation mapping
• Developed audit statics mapping for capturing source and target counts and failure status
• Involved creating file structure as per PDM
• Involved tables created in Database as per PDM
• Involved prepared review check list as per coding standards
• Involved code migration from DEV to SIT
• Involved Error Handling, capturing error records loading into Exception table
• Developed SCD TYPE1 and TYPE2 mapping.
• Giving production support.
• Responsible to load data from flat files, which involved both fixed width as well as delimited files and also from the relational database
• Extensively involved in development of Mappings using various Transformations like Source qualifier, Expressions, Joiner, Aggregators, Lookups, Filter, Rank, Sequence generator and Update Strategy
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Involved in Unit testing for developed mapping.

Confidential

BI Developer

Environment: Informatica 9.x, SQL Server, Windows XP, UNIX, DAC

Responsibilities:

• Involved in analyzing the requirement specification document.
• Involved in configuring Oracle BI Apps 7.9.6.4.
• Involved in preparing the source to target mapping document.
• Worked on all the activities right from running full and incremental loads and fixed the bugs.
• Developed the complex mappings which are part of the star schema.
• Involved in migrating the objects from development to Production.
• Prepared the migration Document.
• Worked extensively with DAC.
• Worked on Performance Tuning.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Involved in Unit testing for developed mappings.

Confidential

ETL Developer

Environment: Informatica 9.x, IBM DB2, UNIX .

Responsibilities:

• Involved in analyzing the mapping specification document.
• Involved in analyzing the data between source and target.
• Prepared solution design and component specifications as per the business requirements.
• Involved in all the development activities right from designing to deploy the code into formal environment.
• Prepared unit test cases and executed in development environment.
• Prepared the validation SQL’s equivalent to Informatica mapping’s to make sure the application is working fine.
• Involved in developing the UNIX scripts to trigger the informatica jobs.
• Involved in preparing the Defect control form for individual component to ensure the quality for the final deliverable.
• Developing Informatica Mappings & Tuning them when necessary
• Optimizing Query Performance, Session Performance.
• Prepared integration test cases for specific component as per the business requirement.

Confidential

ETL Developer

Environment: Informatica 9.x, IBM DB2, UNIX .

Responsibilities:

• Analyzing the High level Design Documents and Analyzing the Requirements and understanding the functionality of both source and target systems.
• Developed Complex Mappings using SCD2 from the High level Design Documents.
• Developing the transformation logic, Identifying and tracking the mappings, heterogeneous sources and determining the hierarchies in dimensions.
• Handling Error Records by maintaining DQ MEASUREMENT Tables.
• Prepared the UTP Documents and Resolved the Defects from the Developed Applications.
• Created the parser rule for the provided XML Source file as per the business requirement.
• Migrated the DT Studio Components to integration service directory.
• Attending Daily status meetings and provided detailed status report to the onsite people.
• Worked as a Project Quality Coordinator and SCM Coordinator.
• Awarded for my good work in the Project.
• Testing the consistency and quality of data that is loaded into warehousing.
• Having knowledge on UNIX.

Confidential, Atlanta

ETL Developer

Environment: Informatica 9.x, Oracle 10 g, UNIX, SQL Developer.

Responsibilities:

• Analyzing the requirements and design documents and understanding the functionality of both source and target systems.
• Analyzing the mappings in Informatica where the new requirement has to implement at the right place.
• Developing the transformation logic, Identifying and tracking the mappings, heterogeneous sources and determining the hierarchies in dimensions.
• Captured data error records corrected and loaded into target system
• We used data warehouse administration console(DAC) to run the jobs, and aware of how to configure
• The DAC and scheduled it.
• Attended weekly status meetings and provided detailed status report to the client.
• Testing the consistency and quality of data that is loaded into warehousing.
• Worked as a Project Security Coordinator.
• Having proficiency in UNIX .