SUMMARY

• 7+ years of experience as a Business Intelligence developer who worked on various Data warehousing applications using Informatica PowerCenter 8.x, 9.x,10.x, Informatica PowerExchange and Informatica IDQ 9.x with extensive knowledge in analysis, design, development, implementation and troubleshooting using Data warehousing Methodologies and Data Modeling. I am a communicative team player committed to excelling in quality and meeting project deadlines.
• 7 years of professional IT experience in analysis, design, development and implementation of Data warehousing applications using Informatica PowerCenter 8.x, 9.x, Informatica PowerExchange and Informatica IDQ 9.x.
• Developed full SDLC project plans to implement ETL solution and identify resource requirements.
• Strong hands on experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience in Agile Software Development methodology.
• Extensive experience in design and development of ETL involved in Source databases - Oracle, SQL Server, Netezza, XML, Flat Files (fixed width, delimited), Main Frame (COBOL Files) and Target databases - Oracle, Netezza, XML, SQL Server 2005 and Flat Files (fixed width, delimited)
• Extensive ETL testing experience using Informatica 9.x/10.x (Power Center) (Designer, Workflow Manager, Workflow Monitor) Oracle Tools and Business Objects.
• Strong experience in Dimensional Modeling using Star and SnowFlake Schema and Implement SCD Type1 and SCD Type2 methodologies in various projects to keep historical data in data warehouse.
• Experience in Performance tuning of Informatica like Sources, Targets, Mappings, Transformations and Sessions.
• Experience in developing complex Stored Procedures, Functions, Views and Triggers, Complex SQL queries as a PL/SQL developer.
• Extensive experience as Tech Lead and managed multiple resources for development projects.
• Expertise in preparing code documentation in support of application development, including High level and detailed design documents, unit test specifications, interface specifications, etc.
• Excellent Communication, Analytical and Programming skills.
• Experience in full life cycle development (SDLC).

TECHNICAL SKILLS

• Data warehousing, ETL and Reporting, Data Quality Management
• INFORMATICA PowerCenter 9.x/10.x, Informatica IDQ 9.x
• Erwin Data Modeler, Toad Data Modeler
• Control M, DAC, ESP (CA Workstation), Autosys...etc.
• Data Profiling, Data Quality
• Netezza DB, Oracle 10g/12g, MySQL, DB2, SQL Server, Teradata.
• MS DOS, Windows 2003/95/98/NT/7/10, UNIX
• Visual Basic, PL/SQL, SQL
• WSDL, XML/XSD, HP Quality Center 9.2, File Transfer (WinSCP), ALM.

PROFESSIONAL EXPERIENCE

Confidential, Irvine - CA

BI/Sr. Informatica Developer

Responsibilities:

• To gather functional requirements from Business and prepare Project Technical design documents for the Development team.
• Prepared Technical Requirements Document, Mapping Documents, and Low Level Design Documents.
• Designing and developing mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Extensively used transformations to implement the business logic for loading the data into target such as Source Qualifier, Joiner, Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Connected Look Up (Target as well as Source) and unconnected Lookup, SQL Transformation and Update Strategy, designed complex mappings involving target load order and constraint based loading.
• Created Informatica Workflows and Worklets as per the business rules to load data into OLTP databases.
• Involved in performance tuning and Query optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage a very large volume of data.
• Moving data into and out of Salesforce objects using the Power Exchange Salesforce.com Adapter for Data Integration.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Use of Teradata and Oracle Databases to get the Customer Data Extract and Load in Salesforce and enable triggers to all the downstream applications for Customer relationship building.
• Extensively used ETL processes to load data from various source systems such as Oracle, Teradata and Flat Files, XML files into target system Oracle by applying business logic on transformation mapping for inserting and updating records when loaded.
• Generated Database triggers, functions and stored procedures and wrote many SQL Queries. Used Physical schema implementation objects like table-space, table rollback segments and created database structures, objects.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager and extensively used UNIX Shell scripts for conditional execution of the workflows.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Implemented full pushdown Optimization (PDO) for Semantic layer implementation for some of the complex aggregate/summary tables instead of using the ELT approach.
• Experience in working with UNIX environment, designed and developed UNIX Shell Scripts, FTP, sending files to source directory & managing session files.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions and troubleshooting sessions using Session logs, Workflow Monitor as well as performance tuning of mappings and sessions.

Confidential, Charlotte - NC

ETL Informatica Developer/Designer

Responsibilities:

• To gather functional requirements from Business and prepare Project Technical design documents for the Development team.
• Provide technical expertise in developing complex Informatica Mappings to extract data from different sources like SQL Server & Flat Files.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Conduct impact assessment and determine size of effort based on requirements
• Lead and guide development of an Informatica based ETL architecture
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed complex Informatica Mappings to implement the business logics & fulfill the business requirements.
• Support in performance tuning of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
• Coordinating with the Testing Team and resolving possible defects.
• Developed DIS jobs as part of ETL scheduling jobs. Trained offshore team on this new in-house scheduling tool.
• Extensively involved in Unit Testing before moving the code to QA and then actively was part of UAT/Regression Testing before the Product was released to Production.

Confidential, Rochester - NY

Sr. ETL Informatica Developer/Designer

Responsibilities:

• Gathering functional requirements from Business and prepare Project Technical design document for Development team.
• Created functional specification Document for each module of the project.
• Provide technical expertise in developing complex Informatica Mappings to extract data from different sources like SQL Server & Flat Files.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Conduct impact assessment and determine size of effort based on requirements
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto Data warehouse.
• Developed complex Informatica Mappings to implement the business logics & fulfill the business requirements.
• Support in performance tuning of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
• Coordinating with the Testing Team and resolving possible defects.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Confidential

ETL Informatica Developer.

Responsibilities:

• To gather functional requirements, determine the scope of the project by working with Business
• Provided project plans, coordinate implementation & planning schedules onshore and offshore
• Define project scope and identify impacts to current business, system and operational processes
• Extensively involved in business and functionality of the system, understanding source systems and requirement analysis
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, lookup, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the Mappings from development to testing and then to production repositories.

Confidential

ETL Informatica/Qlikview Developer.

Responsibilities:

• To gather functional requirements, determine the scope of the project by working with Business
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed dashboards pertaining to KPI monitoring using QlikView10.x.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
• Worked as Subject Matter Expert (SME) for various projects. Taught the users to get along with Qlikview.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, lookup, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.