SUMMARY

• Over 12+ years of Information Technology experience in the analysis, design, development, testing, implementation and support for Data Warehousing projects.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Designed various Mappings for extracting data from various sources involving relational tables & flat files.
• Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools - Informatica Server, Repository Server
• Extensive experience in production support processes, incident management, change management and release management.
• Experience in handling jobs monitoring and production support in a 24/7 environment
• Experienced in doing Error handling and Troubleshooting using various log files.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center ETL tool.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Experienced and comfortable working on various databases like SQL Server, Oracle, DB2 UDB, Teradata.
• Well conversant with test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle.
• Expert in using design and management tools like Erwin and Toad, SQL Developer.
• Experience in identifying performance bottlenecks and tuning of Informatica sources, targets, mappings, Transformations, and sessions for better performance.
• Application Data warehousing experience in Financial, Banking, and Retail.
• Unit testing and Integration test of the ETL code with test cases.
• Proficient in Oracle, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration.
• Excellent Documentation Skills, Team problem solving ability, Analytical and Programming skills in High speed, Quality conscious and multitasked environment.
• Have good knowledge on Microsoft Application tools i.e. MS Access, MS Excel, Pivots, ASP.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Involved in building out ETL's on the core database platform of the client.
• Analyzed existing process flows and business functionalities and prepared ETL process flow document for Predictive analysis.
• Involved in designing Conceptual, Logical and Physical model for Staging and Target data bases.
• Used SQL tools like SQL Server Management Studio to run SQL queries and validate the data in warehouse and mart.
• CreatedInformatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Extensively worked on tuning ofInformatica mappings for better performance.
• Extensive knowledge and worked withInformatica Data Quality for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data.
• Involved in troubleshooting issues related to SQL, SSIS.
• Was involved in basicInformatica administration such as creating users and privileges, folders, optimizing server settings, deployment groups etc.
• Working with Data migration Team to migrate Orders from one system (By design) to another system (Oracle EBS).
• Used Debugger to test the mappings and fixed the bugs. Performance tuning of the mappings and sessions.
• Used Workflow Manager for Creating, Validating, Testing and running the workflows, sessions and scheduling them to run at specified time.
• Migrating code from Dev to QA, QA to UAT and UAT to PROD. Maintaining the version control and release notes in GIT.
• Present data profiling and data validation results to users of data.
• Worked with SQL queries, responsible for data mapping and data cleansing and data validations.
• Developed mapping variables and parameters to support SQL override.
• Tuned performance ofInformatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Performed thorough data validations by writing complex SQL scripts as a part of data analysis and test cycle and identify defects.
• Extracted data from various centers with the data in different systems like Oracle Database and SQL Server and loaded the data into Teradata staging usingInformatica Power Center 9.5.
• Created jobs to load the data from csv files to oracle tables usingInformatica Power Center 9.6. Files are coming from external source and loading them into oracle tables.
• Performed routine DBA jobs like Backups. Restores, checking the integrity of the databases, configuring DB Mail and assigning required roles and permissions to the users.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Experience in writing T-SQL scripts for monitoring Disk free space and Log files full issues.

Environment: Informatica Power Center 9.6, Power Exchange CDC, Oracle, SQL Server 2012, Oracle EBS, PL/SQL, UNIX.

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Involved in theInformatica server installation and setting up the environment.
• Analyze the data from different sources i.e. Oracle, SQL Server and Flat file and define Data Warehouse and ETL processes.
• Designed the Data Warehouse/ ETL processes usingInformatica Power Center to extract, transform and load data from multiple input sources like SQL Server and Oracle to target Oracle database.
• Involved in extensive DATA validation using SQL queries.
• Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc. to implement the user requirements.
• Used Quality Center to create defects based on the information obtained from session logs in case of errors, Data Validation and requirements mismatch.
• Prepared detail documentation on the developedInformatica Mappings/Transformations, andInformatica sessions.
• UsedInformatica Power Exchange Passport tool to analyze COBOL /Mainframe source data for legacy systems.
• UsedInformatica Power Center Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data.

Environment: Informatica Power Center 9.1,Informatica Power Exchange, Oracle 11g, SQL, SQL SERVER, PL/SQL & UNIX