PROFESSIONAL SUMMARY:

• Over 9+ year’s professional experience in IT industry and wide range of progressive experience in design, analysis, development, documentation, coding and implementation including but not limited to Databases, Reporting, Data Warehouse, ETL Design and BI Applications across wide industry verticals.
• Hands on Experience in creating MicroStrategy in developing, administrating, Intelligence Server, and Report Services Using MicroStrategy 9x suite namely Desktop, Web, Command Manager, Object Manager, Enterprise Manager and Narrowcast Server.
• Diversified Domain expertise implementing solutions to Data Warehousing Projects. Work experience in Banking, Finance and Retail domains.
• Strong ETL experience using Informatica PowerCenter 10.1/9.6.1/ 9.5.1/9.1.0 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations and worklets.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse and Data Mart.
• Designed and developed complex mappings, from various transformations like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Databases.
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow Designer & Worklet Designer.
• Knowledge in designing and writing on-demand UNIX shell scripts.
• Co-ordinating with users and establishing good relations between users and development team.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment.
• Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.1/9.6.1/9.5.1/9.1.0 Commission tool Callidus (Understanding of Commission and Callidus reporting)

Reporting Tools: Power BI, Cognos & Micro Strategy 9, 8 Suite (Micro Strategy Intelligence Server, Micro Strategy Desktop, Micro Strategy web Basic knowledge of admin components)

Databases: Netezza, Oracle, DB2, and SQL Server

Languages: SQL, PL/SQL

Scheduling Tools: AutoSys and Appworx

Operating Systems: Windows XP/ 98/2000/2003/2008/2010/2011 & UNIX (Scripting)

PROFESSIONAL EXPERIENCE:

Confidential, NE

Lead Informatica Developer/ Admin

Responsibilities:

• Part of team were we are assigned multiple Jira tasks concerning ETL and ELT solutions.
• Managed the infra-structure within the project.
• Installation and configuration of Informatica Power Center and other related products.
• Managing the DEV/QA/UAT environments and assist Confidential GIO team on PROD environment with High Availability and GRID setup
• Setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Appworx
• Interact with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades
• Monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language
• Support multiple Informatica environments, production and development
• Support development teams with performance tuning and troubleshooting issues
• Handling Informatica components migration tasks
• Scheduling and Monitoring Informatica repository backups
• Scheduling jobs through Appworx for monthly and daily job cycles
• Creating new repositories from scratch, backup and restore
• Scheduling real time system jobs
• Root Cause analysis for ETL job failures/Data issues raised by business
• End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup
• Source Data Extraction and validation.
• Perform the DR test and exercise to ensure the Actual & DR environments are in Sync.
• Managing the super user accounts that used to connect to Informatica, Database & Server.
• Maintaining the code inventory.
• Creation of ETL and ELT code in Informatica to manage data integration tasks within the company.
• Actively Involved in the development of Converting Ab-initio code into Informatica
• Review of Informatica design documents and working closely with team to ensure correct standards are followed.

Environment: Callidus, Informatica PowerCenter 10.1 (PowerCenter Designer, workflow manager, workflow monitor), Informatica PowerCenter 9.6.1, Power BI, Cognos, IBM DB2, Netezza, Unix Shell Script, PL/SQL, Appworx,.

Confidential, FL

Data Integration Consultant

Responsibilities:

• Involved in requirement gathering with business users and converted them into mapping documentation.
• Extensively word on Informatica PowerCenters tools like Designer, Workflow Manager and Repository Manager.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Union, Rank and more.
• Developed complex mappings and involved in tuning for better performance.
• Designed and executed error handling process using Informatica Debugger.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed number of Complex Informatica Mappings and Reusable Transformations based on the business rule.
• Involved in creating SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using connected/unconnected Lookups.
• Created Reusable Transformations and Mapplets based on the business rules.
• Involved in Performing Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts to implement ETL process on daily/monthly jobs.
• Involved in creating best practice documents for ETL Process.
• Involved in coordinating with DBA to increase performance of ETL process by creating indexed on target tables as required.
• Collaborated with development and testing team to support end to end testing.

Environment: Informatica PowerCenter 9.6.1, Netezza, Aginity, UNIX, Windows XP/7, SQL Server, AutoSys.

Confidential, VA

Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.
• Responsible for Developing Informatica development life cycle process documents.
• Created various PL/SQL stored procedures,, functions, views, Cursors, indexes on target tables
• Extracted data from various sources like Oracle, flat files and XML.
• Development of mappings as per the technical specifications approved by the client.
• Developed mappings using Informatica PowerCenter Designer to transform and load the data from source systems to target database.
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance and Worked on different sources like Oracle, flat files.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Used mapping variable for imparting flexible runs of workflows based on changing values.
• Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Created sessions and workflows to run with the logic embedded in the mappings using PowerCenter Designer.
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica PowerCenter
• Created various tasks like sessions, decision, timer and control to design the workflows based on dependencies.
• Co-ordinating with users and establishing good relations between users and development team.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.

Environment: Informatica PowerCenter 9.5.1, Oracle 10g, TOAD, SQL Server, UNIX, AutoSys.

Confidential, TX

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool by using Source Analyser, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Joiner, Update Strategy and Rank.
• Extensively involved in Performance Tuning issues.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Migrated Mappings, Sessions and Workflows from Development to Test and then to Production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in developing ad-hoc and business reports according to the requirement.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.

Environment: Informatica PowerCenter 9.1.0, Oracle 11g, TOAD, PL/SQL, UNIX, Windows XP/7, SQL Server, AutoSys.

Confidential

Informatica Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Worked with different sources such as relational databases, flat files for extraction using Source Qualifier and joiner.
• Created the mappings using the transformations like Source Qualifier, Joiner, and Lookup, Filter, and Update strategy.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Work lets for data loads. Created reusable transformations and Mapplets to use in multiple mappings
• Implemented performance issues on mappings to increase the efficiency of loading the data from various metrics to the target database.
• Created sessions and workflows to run with the logic embedded in the mappings using PowerCenter Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Informatica PowerCenter 8.1, Oracle 10g, TOAD, UNIX, Windows XP.