Objective

• To excel in the field of Information Technology as a Business Intelligence Developer by contributing continuously towards organizational growth by providing seamless system support and to utilize every opportunity to achieve both personal and professional development.

SUMMARY

• 6 years of total IT experience in analysis, design, development, implementation and troubleshooting in the area of ETL tool Informatica
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing
• Extensive experience in designing and developing ETL involving databases Oracle, MS SQL Server, Flat Files (fixed width, delimited), XML,DB2
• Worked extensively with data quality teams to ensure the Data Quality
• Worked on various ticketing systems to resolve issues
• Extensive experience in handling ETL using Informatica PowerCenter
• Extensively worked on Informatica Designer components - source analyzer, warehouse designer, transformation developer, Mapplet and Mapping Designer
• Strong experience in using workflow manager Tools - Task Developer, Workflow & Worklet Designer
• Extensively used Informatica Repository Manager and Workflow Monitor
• Strong experience in developing complex mapping using varied transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker, Normalizer, Joiner, Stored Procedure, Update Strategy and Re-Usable transformations
• Strong experience in developing Workflows, Worklets, Sessions and Tasks to effectively manage the load
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica load for better performance and efficiency
• Extensive experience in Error handling and Problem fixing in Informatica.
• Strong knowledge of different schemas (star and snow flake) to fit reporting query and business analysis requirements
• Excellent knowledge in creating database objects like stored procedure, Views, Functions.
• Good knowledge of Oracle, MS SQL Server
• Good working knowledge in Pharmaceutical and Retail domain
• Self-motivated and able to work independently and as a member of a team
• Excellent Communications, Interpersonal and Analytical skills with ability to prioritize multiple tasks
• Quick learner and adaptive to new and challenging technological environments

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter.

RDBMS: Oracle, MS SQL Server, DB2.

Reporting Tools: OBIEE.

Languages: SQL, PL/SQL

Operating System: UNIX, Windows

Office Tools: Microsoft Office, Excel.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Environment: Informatica PowerCenter 9.5, Oracle10, OBIEE, UNIX Shell scripting.

Responsibilities:

• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team
• Identified, recommend and implemented ETL process and architecture improvements
• Conducted impact assessment and determine size of effort based on requirements
• Established best practice and standard for ETL process documents
• Designed ETL architecture and architecture documents
• Defined and implemented ETL development standards and procedures
• Troubleshoot and implement existing code
• Analysed all errors generated by Informatica and fixed those errors
• As an ETL Developer, involved in entire data warehousing life cycle design and development
• Working with various active & passive transformations like expression, lookup, filter, rank, aggregate, update strategy, joiner, Stored Procedure etc.
• Involved in Design & development of Informatica PowerCenter Mappings, Workflows.
• Involved in the design & development of database objects and SQL queries in development of ETL.
• Developed test Scripts, test data for Unit testing.
• Assisted during migration.
• Interact with client on a daily basis and Detailed Requirements Study.

Confidential

Software Developer

Environment: Informatica PowerCenter 9.5, Oracle 9i, UNIX Shell scripting.

Responsibilities:

• Requirement Analysis.
• Used Data Warehouse techniques like Star-Schema.
• Working with various active & passive transformations within Informatica Like expression, lookup, filter, rank, aggregate, update strategy, joiner, Stored Procedure etc.
• The project called for extensive work using the Informatica tool involving - Source Analyzer, warehouse designer, Mapping designer & Mapplet and Transformations and Parameter Files.
• Tested the target data against source system tables bytaking a text file dump.
• Communication with the client for Daily and Weekly status report.
• Providing production support and ensuring client satisfaction.
• Increasing client confidence by proactively addressing production support issues and providing recommendations for performance/process improvement.

Confidential

Software Developer

Environment: Informatica 9.5, Oracle, UNIX Shell scripting.

Responsibilities:

• Prepared understanding document on the requirements after discussing with onsite team.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in tuning SQL queries.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregatorsfilters, lookup and update strategy transformations.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Enhanced performance for Informatica session using large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Worked in loading data in Data Staging and cleanup process.
• Developed test cases and Involved in Unit testing and system integration testing.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings
• Handled system utilization issues, performance statistics, capacity planning and recovery of databases.
• Monitoring day - to-day Process for different Data Loads and resolving Issues.
• Provide status reports to the Core Team and Stakeholders including progress, milestones and issues.
• Trained the newly joined resources in the project.

Confidential

Software Developer

Environment: Informatica PowerCenter 8.6, Windows, UNIX, Oracle.

Responsibilities:

• Through analysis of client requirements and providing end-to-end solution.
• Designing technical documents for the project.
• Developing components using standard codes and procedures.
• Performing unit testing and integration testing prior to component deployment.
• Preparation of release notes
• Supporting project deployment
• Loaded Operational data from Oracle source tables into Interim tables and cleansed the data using appropriate business rules.
• Implemented different transformations like Source Qualifier, Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, and Router Transformations.
• Tuned performance of Informatica session for large data files by increasing target based commit interval and by Lookup caching and Lookup override and indexing the columns used in where condition of the query.
• Generated Reusable Transformations and used them extensively in many mappings.
• Implemented Variables and Parameters in Mappings.
• Involved in Unit Testing, Module Testing, System Testing
• Providing production support and ensuring client satisfaction.
• Coordinate the on time and quality deliveries of the project data using appropriate business rules.

Confidential

Software Developer

Environment: Informatica PowerCenter 8.6, UNIX, Oracle 9i, Flat Files.

Responsibilities:

• Analysed all the documents related to technical and functional.
• Involved extracting the sources from Oracle, flat file sources.
• Developed extensively the mappings according to the design document.
• Tested all the possible business rules available and session properties available in Informatica.
• Used Mapping Parameters and session parameters.
• Used Target Load Order for populating various targets within the same mapping.
• Implemented Slowly Changing Dimension Type 2 - Current Flag to maintain historical information.
• Tuned the mappings and involved in performance improvement phase.
• Identified all the defects and used the defective analysis approach