SUMMARY

• Accomplished data warehouse specialist with successful experience in implementing large scale data warehouses while participating in all phases of the project such as data warehouse architecture, development, system analysis, testing and deployment.
• Around 11 years 8 months of extensive IT industry experience in Requirement Gathering, Analysis, Design, Development, Testing, Implementation and Maintenance Support of ETL/Data warehouse solutions using Informatica PowerCenter.
• Worked in multiple roles like Technical lead, Project leads, Auditor, Interview panel for multiple technical interview for the company.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Strong experience with client tools of Informatica PowerCenter
• Proficient in creating Mappings, Sessions, Workflows, Transformations, Mapplets, Worklets, Command Tasks and E - mail Tasks
• Diversified experience in implementation of projects with multiple domains like Health care, Banking and Finance.
• Tweaked the complete ETL system by collecting performance data, used various Performance Tuning methods on source, target, mapping and session.
• Good understanding of Enterprise Application Integration requirements and design.
• Proficient in implementing and providing business intelligence on data warehouse and data mart solutions.
• Hands-on-Experience in preparation of Design Specs, Unit Test Cases and Deployment Plans
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Expertise in implementing complex Business rules by creating robust mappings.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Consecutive 4 times Best Auditor of the Quarter winner.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.x/8.x/7.x, Informatica Power Exchange

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2000

Operating Systems: Unix, Linux, Windows NT/XP/2000/2003, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential

Sr Data Warehouse Engineer

Responsibilities:

• Participate in meetings responsible for business analysis and requirements collection.
• Involve in requirement gathering, business analysis, design and development, testing and implementation of business rules.
• Perform business requirement gathering and analysis.
• Managed the development team of 4 developers at onsite.
• Prepare the high-level design for the application
• Coordinate the development and testing activities and ensure delivery quality
• Convert application designs into data model and interface/data mapping specifications
• Gather and analyze business requirements and produced required documentation for any changes
• Serve as the liaison between technology and business end users
• Address multi project release assessment and management
• Code review and verification of standards and guidelines
• Streamline complex requirements to simplify functional system design
• Prepare and presented subject matter knowledge, analysis, options, solutions in both written and presentations to internal and external audiences
• Work on incident and problem management for system production issues
• Manage end-to-end from idea to delivery of enhancements and changes to systems
• Streamline complex requirements to simplify Business Processes
• Adhere to standards and checklists provided

Environnent: BODS, Oracle, Flat Files, Redwood

Confidential, Cincinnati, Ohio

Data Warehouse Engineer

Responsibilities:

• Participated in meetings responsible for Business Analysis and Requirements Collection.
• Managed a team of 5 developer at onsite.
• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Developed & Reviewed Complex mappings, Sessions/workflows.
• Coordinated with source system owners, day-to-day ETL progress monitoring.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Performed Functional testing & Unit testing for the Informatica mappings.
• Used informatica to migrate data from oracle database to Flat Files which are used as Staging Files.
• Designed informatica mappings to publish a daily and monthly events files to be consumed by downstream systems.
• Created Documents such as Technical Systems Design, Source-To-Target Data mapping Document, Unit Test Cases and Migration Documents for Production support.
• Maintained naming standards and warehouse standards for future application development.
• Developed test plans and test cases at various interfaces of the project.
• Assisted in creating and manage daily and monthly data operations and schedule processes.
• Designed Informatica workflows and mappings for optimal performance in a large scale Unix/RDBMS environment. Tuned Informatica workflows for better performance.

Environnent: Informatica- Power Center 9.5, Oracle 11g, Flat Files, Unix, Oracle, Autosys

Confidential

Informatica Lead

Responsibilities:

• Responsible for Business meeting, conversion of business rules into technical specifications.
• Designed the scheduling of 62 interfaces with high complex schedules.
• Totally 300 + mappings & 400+ sessions were developed and scheduled.
• Designed the scheduling for 62 workflows following 9 different calendar runs.
• Worked extensively on scheduling design & got client appreciation for design.
• Extensively involved in the Analysis, design and Data Modeling.Coordinated with Data modeler to create Star Schema data model design using Erwin.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Developed complex ETL Mappings and Maplets in Informatica to load data from various sources to Data warehouse.
• Developed Shell Scripts which take care of truncate table, Archival the source and the target files and Clean up the log files
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Mentored the team of 8 technical persons for any technical issues, enhancement to the existing system, fixing the issues in the existing system or new changes.
• Developed UNIX Shell Scripts for scheduling the workflows in Informatica.
• Migrated mappings, sessions, and workflows from development to testing environments.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Collaborate with Solutions Architect and Data Architect to understand business requirements.
• Supported full testing cycle for ETL processes, including bug fixes.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Worked closely with reporting team to generate various reports.
• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Responsible for trouble shooting, identifying and resolving data problems.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data.
• Used PMCMD command & UNIX Shell scripts to automate the process.

Environment: Informatica Power Center 8.6.1, Oracle 11g, Flat files

Confidential

Technical Lead

Responsibilities:

• Requirements gathering from business analysts and responsible for populating the business rules using mappings into the Repository for Meta Data management.
• End-to-end ETL development of the Data Mart. Designed and developed Informatica mappings for data loads.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Took part in sessions to define the Business requirement specifications and Functional specifications by directly interacting with the users and proposing corresponding deliverables.
• Designing automation of ETL jobs using Informatica batches and Pre-Session and Post-Session UNIX scripts using Korn shell scripting in VI editor.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings; sent notification e-mails.
• Tuned inefficient queries using combinations of index creation, alternate indexing strategies, join strategies and query level optimization hints
• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)

Environment: Informatica Power Center 8.6.1, Oracle 11g, Flat files, SQL, Windows 2000

Confidential

Informatica Developer

Responsibilities:

• Involved with business analysts to understand the business requirement specifications and implemented the ETL jobs using Informatica Power Center to create conceptual, logical and physical data models and deployed the solutions that maximize the consistency and usability of data.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Group Members and Technical Manager regarding any technical and Business Requirement issues to bridge the gap between user needs and tool functionalities.
• Running the SQL scripts from TOAD
• Worked in various types of transformation like Lookup, Update Strategy, Joiner, Filter, Aggregation, Rank, Router to extract the data from multiple source systems like Oracle, SQL Server and .csv files
• Creation of Reusable transformations, Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Collaborate with the Data Warehouse team to design and develop required ETL processes and Created technical design specifications for the ETL programs.
• Performance tuning, Maintenance and enhancements of ETL programs and scripts.
• Developing the maplets, worklets, reusable transformations and shortcut objects.
• Worked on Java transformation to address the business requirement
• Responsible for Testing and Validation of the code in the mappings using the data populated.

Environment: Informatica Power Center8.6.1, Oracle 10g, SQL, Shell Script and UNIX.

Confidential

Informatica Developer

Responsibilities:

• Worked with Business analysts for gathering requirements & involved in data modeling of the system.
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Responsible for the definition, development and testing of the ETL mappings necessary to extract data from the client's operational databases, Transform and cleanse the data, and Load it into the data marts.
• Responsible for the analyzing and comparing complex data from multiple sources (Teradata, Oracle, flat files).
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the Informatica mappings for better performance
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Actively interacted with business analysts.
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• ETL mapping Documents for every mapping and Data Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL Server 2000, Flat Files, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and come up with the design for the Data Warehouse and Data Mart.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier Transformation, and Update Strategy Transformation.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Developed separate mappings for the Data Cleaning and Scrubbing and implementing the Data warehousing Standards.
• Starting Sessions and Batches and make Event based scheduling using Informatica Power Center.
• Implementing the complex business rules by creating transformations, filter Expression, Lookup, Joiner, Sequence generator transformation.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created reusable transformations and used in various mappings.
• Developed Informatica parameter files to filter the daily source data
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Extensively used Informatica Scheduler to Schedule Informatica Workflows.

Environment: Informatica PowerCenter, Oracle 9i, UNIX, Windows NT/2000

Confidential

Informatica Developer

Responsibilities:

• Understanding the customer Requirement and designing the solution documents.
• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL
• Worked in Data modeling, Data mapping and Data flow
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Informatica Power Center tool.
• Worked with various active transformations in Informatica Power Center like Filter
• Involved in Requirement gathering and writing Functional and Technical documents
• Responsible for writing and modification of mappings & workflows
• Tune the SQL queries and complex procedures to improve performance

Environment: Informatica PowerCenter, Oracle 9i, HP UNIX