SUMMARY:

• Having 8+ years of IT experience in Analysis, Design, Development and Implementation of Enterprise Data warehouse projects using ETL processing tool Informatica7.x,8.x and 9.x in various domains like Telecom, Commission system and retail and exposure with OLAP reporting tool Business Objects and Cognos.
• Currently working as Senior ETL Developer/Analyst.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business community and developers across multiple disciplines.
• Proficient in understanding business processes, requirements and translating them into technical requirements and test strategies.
• Experience in coordinating and collaborating with onsite development and Business teams.
• Experience in Design, development and Deployment of business application for Dealer Commission System and centrally Managed Sales Portal.
• Deliver project road-map including initial source data definition, mapping, detailed ETL development specifications and documentation of all operations.
• Extensively worked on post-production support and resolving any issues, using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logsExperience in Callidus (Truecomp 5.1 Version).
• Expertise in using Informatica (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) .
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake schema and Slowly Changing Dimensions.
• Involved in Full Project Life Cycle for building Data Warehouse
• Developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer.
• Experienced in Performance of Mapping Optimizations in Informatica.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.

TECHNICAL SKILLS:

ETL: Informatica, Power Center 9.0.1/8.6.1/7. x.

Languages: SQL, PL/SQL, C, C++.

Databases: Oracle 11i/10g/9i/8i, SQL Server, MS-Access, SQL, Teradata.

OLAP Tools: Cognos 7.0/6.0, Business Objects.

Operating System: UNIX, Windows (98, 2000, NT, XP).

PROFESSIONAL EXPERIENCE:

Confidential, Austin,TX

Senior ETL Developer

Responsibilities:

• Interacting with Business Analyst to understand the business requirements.
• Analyzing requirements to refine and transform into functional specifications.
• Analysis of the specifications provided by the clients.
• Review of mapping documents to start development.
• Extracting data from sources like Oracle and Flat Files using Power center designer and transforming them using the business logic and loading the data to the target warehouse.
• Developing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Coordination of system/Integration/UAT testing activities with other teams involved in project and review of test strategy.
• Fine tuning mappings and sessions to improve performance.
• Coordinating with business and EST teams for closure of UAT defects and creating

  adhoc reports for end users.

• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.

ETL Developer

Responsibilities:

• Interacting with Business Analyst to understand the business requirements.
• Analyzing requirements to refine and transform into functional specifications.
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart.
• Extracting data from sources like Oracle and Flat Files using Power center designer and power exchange and transforming them using the business logic and loading the data to the target warehouse.
• Designing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Coordination of system/Integration/UAT testing activities with other teams involved in project and review of test strategy.
• Fine tuning mappings and sessions to improve performance.
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Keep track of all CI list, maintaining versions and Change requests.
• Increasing client confidence by proactively addressing production support issues and providing recommendations for performance/process improvement.

Senior Informatica Developer

Responsibilities:

• Gathered and analyzed requirements by meeting business stakeholders and other

  technical team members prior to the design of ETL.

• Understanding High Level ETL Requirement specifications to develop LLD.
• Created the mappings using different transformations like Source Qualifier, Expression, Filter, Router and Lookups based on the requirements.
• Preparation of Unit test Cases, System Test Plan and System Test Cases.
• Involved in more than 3 code MTP’s (Move to Productions).

Business Analyst / Application Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Developed standard ETL framework to enable reusability of similar logic in all data operations.
• Involved in System Documentation of Dataflow and methodology.
• Performed Configuration Management to migrate Informatica mappings, sessions and workflows from development to test to production management.
• Involved in Preparation of high level Design document for Data Integration
• Prepared Micro Design documents for DI Interfaces.
• Created and executed sessions using Workflow Manager.
• Used Source Analyzer and Target Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Understanding existing business model and customer requirements.
• Used Transformation Developer to create the Joiner, filters, Router, lookups, Expressions, Aggregation transformations, Update strategy, Stored Procedure Transformations used in mappings.
• Interaction with VF AU directly and assisting them in all issues and enhancement work.
• Unit testing and System testing the mappings.
• Preparation of Unit test Cases, System Test Plan and System Test Cases.
• Fixing defects for the coding while integration testing.