SUMMARY

• Seeking a position to work as a Informatica Lead Developer for a reputable organization and to be able to exercise my skills and further enhance my career leading to greater accomplishments in the implementation of high quality software using good project management, quality processes and tools.
• 11 years of experience in Informatica PowerCenter/Data warehousing.
• Extensive experience in Data Warehousing projects in Collecting Client requirements,Data modeling and Development experience in ETL tool informatica designer,Workflow manager, Workflow monitor, Repository manager.
• Strong experience in implementation of slowly changing dimensions, Star Schema, and Snowflake Schema
• Strong hands on experience in development and design of ETL methodology for supporting data transformations and process in a Enterprise wide ETL Solutions using Informatica Power Center 9.x
• Onsite - offshore model experience.
• Strong Knowledge on MDM Informatica tool.
• Demonstrated capabilities in developing project plans, estimations, resource allocation and utilization, and scheduling of project deliverables for Dev/QA phases of project.
• Hands on experience on Anaplan forecasting tool.
• Experience in identifying and resolving ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.
• Strong skills in SQL, PL/SQL functions, stored procedures.
• Experience in DATAFLUX using Df PowerStudio, Df PowerArchitect for creating architect jobs for monitoring and evaluating data checks/data quality.
• Certified Teradata Master.
• Trained on SAP Tools: BODS and HANA, hands on experience on BODS.
• Worked with multiple relational databases such as Oracle 11g, SQL Server 2000/2005, Teradata V2R5.
• Experience with OBIEE using Physical layer, Business and Mapping layer and Presentation Layer .Worked extensively on Answers,DashBoards,Alerts and IBots.
• Experience in Teradata along with Teradata SQL Assistant and BTEQ experience. Solid skills and knowledge of Teradata version V2R5 and utilities including TPump, MLoad & FAST Load.
• Experience in UNIX Shell Scripting.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Developed test case’s for business and user requirements to perform System / Integration / Performance testing.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Provided off-hour and weekend production support on a rotational, on-call basis.
• Carried out training sessions for end-users (Business users).
• Team and Independent Player with excellent Organizational and Interpersonal skills. Excellent written and oral communication skills.

PROFESSIONAL EXPERIENCE

Confidential, CA

Informatica Consultant

Environment: Informatica 9.1, Oracle DRM, Oracle 11g DB, Linux, SAP BODS, Anaplan, IBM Ilog

Responsibilities:

• Worked in Informatica 9x/ 8x for the ETL from MS Sql server source to the governance technology data warehouse.
• Worked with Business Analyst to understand the functional specification of the project.
• Created Technical Required document based on the FRD.
• Provide the estimated timelines for Integration work.
• Lead the projects with onsite-offshore model.
• Involved in evolution of integration/informatica design and architecture.
• Completed the development of informatica mappings, sessions and workflows.
• Worked with Trillium libraries for cleansing the address fields.
• Worked on Oracle DRM tool and IBM Ilog server.
• Created Unix scripts that are required to process the data from source to target which includes
• Sftp scripts, encrypting and decrypting scripts.
• Designed and developed the error handling mechanism by using the oracle stored proc and Unix scripts.
• Effectively providing support during UAT Testing.
• Maintaining effective communication between cross-teams.
• Worked on EBS Concurrent Program Mananager for Inforamtica job scheduling.
• Providing support activities /Enhancements for ETM.

Confidential, Sanjose, CA

ETL/Data Analyst

Environment: Informatica 8.6, Teradata R12,Oracle 9i,Obiee 10.x.,Trillium

Responsibilities:

• Interacted with Business Analyst (Line of Business) to understand requirements and translated them into the appropriate technical solution.
• Involved in defining data parity definitions/limitations for Bookings and Products Subject areas.
• Created CR’s extensively to fix data issues on TD (Long-term fixes/Short-term fixes).
• Used Data Flux tool extensively to compare data between Oracle and Teradata.
• Created SQL scripts for data validations on daily basis in Products Subject area.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping’s run process.
• Collecting requirements for data quality checks to be done for data within various application and data across applications using Dataflux.
• To define data quality rules especially for those data elements where the data quality is not controlled by application itself due to various limitations in the applications.
• Created Architect jobs to compare data between source and target databases and monitoring data quality on daily basis.
• Worked with Informatica PowerCenter to create mappings for extracting data from various database sources which include oracle and Flat files.
• Worked on OBIEE for generating reports and dashboards for DQG (Data Quality & Governance) project.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Migrated data from Oracle to Teradata by writing BTEQ, Fast Load and MultiLoad scripts.
• Wrote Teradata BTEQ, Fast Load, MultiLoad, TPump and Fast Export scripts to import / export data.
• Created pre-session and post-session shell scripts and mail-notifications.
• Generated SQL queries and validated the data loads using TOAD and SQL Assistant.
• Implemented change detection process to send only incremental loads.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Worked with trouble shooting in Production support and was responsible for fixing failed tests in Production Server.
• Coordinated with system and business analyst for early investigation of data.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedules
• Knowledge transfers with team members for efficient design of the mappings and programs.
• Worked on information that is secure, accurate, consistent, organized, and timely as in an enterprise or corporate claims data warehouse.

Environment: Informatica 8.6.1, Oracle 10g, Teradata V2R6, Windows NT, SQL,PL/SQL, TOAD,OBIEE,DATAFLUX.

Confidential, Pleasanton, CA

ETL Development Lead

Environment: Informatica 8.6, Teradata R12,Oracle 9i.

Responsibilities:

• Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback.
• Experience translating business requirements into Conceptual and Logical Process and Data Models.
• Experience in preparing Logical data models as well as Physical data models and document the same.
• Worked with DBA’s to design and build the Staging/Target databases.
• Worked in Informatica 8.6 for the Extraction, Transformation and Loading from various sources to the enterprise data warehouse.
• Developed and tested extraction, transformation, and load (ETL) processes.
• Involved in change data capture (CDC) ETL process.
• Created sessions and workflows for the source to staging data flow and staging to Target loading.
• Implemented Type II changes for different Dimensions.
• Developed functions and stored procedures to aid complex mappings.

Confidential, Sunnyvale, CA

Informatica Consultant /Onsite Co-ordinator

Environment: Informatica 7.1, Oracle, Oracle Apps, Unix (AIX).

Responsibilities:

• Worked in Informatica 7.1 for the Extraction, Transformation and Loading from various sources to the enterprise data warehouse.
• Interacting with the Business Analysts to get the project requirements.
• Responsibilities including Production support and enhancement.
• Involved in bulk extracts as well as change data capture (CDC).
• Created sessions and workflows for the source to staging data flow and staging to Target loading.
• Design, Development and tested of the various Mappings and Mapplets involved in the ETL process
• Implemented Type II changes for different Dimensions.
• Developed functions and stored procedures to aid complex mappings.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.

Confidential, NJ

Informatica Consultant

Environment: Informatica 8.1, MS Sql Server, Oracle 10g, UNIX, DB Artisan.

Responsibilities:

• Worked in Informatica 8.1 v for the ETL from MS Sql server source to the governance technology data warehouse.
• Created sessions and workflows for the source to staging data flow and staging to data warehousing.
• Design, Developing and testing of the various Mappings and Mapplets, worklets and workflows involved in the ETL process.
• Implemented Type II changes for Project and Organization Dimensions.
• Developed stored procedures to aid complex mappings.
• Involved in fixing invalid Mappings, testing of Stored Procedures, Unit and Integration Testing of Informatica Sessions and the Target Data.
• Created Unix scripts and tested for documented in detail the same and implemented it during the quality analysis phase.

Confidential, Boston, MA

ETL Consultant

Environment: Informatica 8.1, Mainframe, Oracle 9i, UNIX (AIX), Toad.

Responsibilities:

• Worked in Informatica 8.1 for the ETL from various sources to the central data warehouse.
• Design, Development and testing of the various mappings involved in the ETL process.
• Instead of using Normalizer Transformation, I designed a mapping for concatenating the mainframe fixed length flat files.
• Created customized transformations to handle miscellaneous characters.
• Created different mapplets, and worklets as per the business requirements.
• Implemented a common Error handling for all the workflows loading fact data.
• Implemented Type I and Type II slowly changing dimensions.
• Informatica components for daily and monthly incremental loading of around 50 tables were designed.
• Created Unix scripts for scheduling.
• Testing was done for all the components including Unix scripts.
• Took part in migration of jobs from DEV to UAT.
• Performance tuning of the existing production systems was done.
• Documented and presented the production support documents for the components developed to the production support team.
• Given production support for initial one month.

Confidential, Sanjose, CA

Informatica Consultant

Environment: Informatica Power Center 8.1, Oracle 10g, SQL * Plus, Business Objects xi, Toad 7.6.0.1.1, Windows XP 2002.

Responsibilities:

• Validation of Informatica mappings for source compatibility due to version changes at the source level.
• Conversion of oracle procedures to informatica mappings
• Data Validations after source up gradation
• Customization of mappings to accommodate new environment
• Performance Tuning of Informatica mappings
• Repository migration for Development, SIT & UAT environment
• Changed universe design to accommodate new business requirements
• Created new Deski reports and Webi reports as per user requirements
• Documentation of existing informatica mappings
• Created UAT environment for informatica by creating repository from the production repository.
• Took backup of repository from production and restored it into DEV and UAT.
• Migration of reports from 6.5 to XI R2

Confidential, Minneapolis, MN

Informatica Consultant

Environment: Informatica 7.1, DB2 v7, Oracle 9i, Unix (AIX).

Responsibilities:

• Involved in preparation of Detail Design specification and functional Specifications for the ETL programs/business processes.
• Worked in Informatica 7.1 for the ETL from various sources to the central data warehouse.
• Created mappings, sessions, workflows for loading three fact tables and 6 dimension tables.
• Design, Development and testing of the various mappings involved in the ETL process.
• Extensively used Transformations like Router Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation and Sequence generator.
• Implemented a common restart strategy for all the workflows.
• Implemented Type I and Type II slowly changing dimensions.
• Informatica components for daily and monthly incremental loading of around 50 tables were designed.
• Session partitioning was done as a part of performance tuning.
• Created unix scripts for scheduling.
• Created test cases for sample testing and full load testing.
• Testing was done for all the components including unix scripts.
• Took part in migration of jobs from DEV to UAT.
• Performance tuning of the existing production systems was done.
• Documented and presented the production support documents for the components developed to the production support team.

Confidential, Boise, Idaho

Informatica Consultant

Environment: Informatica 7.1, Teradata, Mainframes, Unix (AIX).

Responsibilities:

• Worked in Informatica 7.1 for the ETL from various remote sources to the central data warehouse.
• Involved in bulk extracts as well as change data capture (CDC) from remote Mainframe source using San info mover.
• Created sessions and workflows for the source to staging data flow and staging to presentation layer loading.
• Design, Development and tested of the various Mappings and Mapplets involved in the ETL process
• Scheduled the workflow for the change data capture for the source
• Implemented Type II changes for Currency and Unit Of Measure Dimensions.
• Developed functions and stored procedures to aid complex mappings.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Created master workflow for the daily extract from the remote sources and to the staging area and then to the presentation layer.
• Validation done between presentation layer and source layer by running SQL against the sources and by checking the reports from the data warehouse.
• Created unit testing scripts and tested for documented in detail the same and implemented it during the quality analysis phase.
• Involved in creating and developing reports using Report Net1.1, Cognos 8.0.

Confidential

Room Design Engineer

Environment: Manufacturing of High Precision Components

Responsibilities:

• The company has state-of-the-art technologies and systems to ensure high quality levels and consistent performance.
• They are constantly striving for prompt customer service and stringent scheduling of planned deliveries with enormous success.
• With steady and multi-faceted growth and by engaging qualified manpower who are being exposed constantly to latest trends in the field, the company is able to comply with Global quality standards.
• Thus the company was able to participate successfully in Export Markets to countries like USA, France, Italy, Singapore, Canada and China.
• I worked in SKM tools as a Design engineer worked on different advanced tools like Pro-E, CAD/CAM and Unigraphics to create desings for a variety of engineering components.
• I also worked on generating programs for CNC machines using Unigraphics..These components are used in different industries like Indian Army,BHEL etc.
• And also they export precision components to USA, France, Italy, Singapore, Canada and China.