SUMMARY

• Around 6+ Years of experience in information technology and Data Warehouse Development, Design, Mapping, Extraction, Migration, Data Conversion, Data validation and Development of ETL.
• Extensively worked in Extraction Transformation Loading (ETL) process using Informatica 10.2/9.x/8.x/7.x/6.x, Informatica Power Exchange 9.x Oracle, SQL Server, Mainframes, Netezza, DB2, SAP, Salesforce, Seibel, Linux, Unix and developing user - centric data models, queries.
• Strong experience in principles of DW concepts like Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Strong Data Warehousing ETL experience using Informatica Power Center Client tools - Designer, Source Analyzer, Target Designer, Transformation Developer, Mappings and Mapplets Designer along with Workflow Manager and Monitor tools.
• Proficient in using Informatica Designer, Workflow manager, Workflow Monitor, Repository Manager to create, schedule and control workflows, tasks and sessions
• Expertise in creating cubes and dimensions (SSAS) and Creating Reports with complex formulas and to query the database for business Intelligence using SSRS.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Experience working with Informatica Data Quality (IDQ) for data cleansing, data matching and data conversion.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Extensively worked with Informatica MDM (Master Data Management) to manage the high-volume data.
• Experience in Agile software development methodology and implementations.
• Designed and developed business rules to generate consolidated data using Informatica data quality tool.
• Proficient in developing Informatica IDQ transformations like Parser, address validator, standardizer, labeler, Match, case, Merger and Exception transformation.
• Hands on development using Power BI desktop and integrations with the cloud.
• Designed Mappings using Informatica Big Data Edition (BDE).
• Imported Mappings to applications and executed those using UNIX commands.
• Exported mappings and Rules from BDE to Power center for scheduling workflows.
• Expertise in working with relational Databases such as Oracle, DB2, SQL Server, Netezza.
• Excellent knowledge in data warehouse development life cycle including Software Development Life Cycle (SDLC), including business requirement analysis, data mapping, build, unit testing, user acceptance testing and implementation of slowly changing dimensions.
• Expert in writing critical ETL procedures that extract data from different data feeds, transform and load into Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner that is used by business users in the form of reports.
• Expert in designing and developing backend PL/SQL packages in database layer, functions and triggers.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Bulk Insert, BCP, and XML.
• Extensive experience in Requirement Gathering, Customization, Maintenance and Implementation of various Business Applications.
• Hands on experience in resolving errors using Debugger, Log files of Session & workflows and troubleshooting, performance tuning, and optimization ETL Mappings.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Performed activities including execution of test plans and design of exception handling strategy. Completed documentation in relation to detailed work plans, mapping documents.
• Analytical and Technical aptitude with the ability to solve complex problems Can work very well in a team as well as independently under minimum supervision

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 10.1/9.6/9.5/8.6/8.1/7.1 , Metadata Manager,IDQ,SSIS,DataStage.

Reporting Tools: Business Objects XIR2/6.1/5.0,Qlikview,OBIEE, Oracle Analytics, etc.

Databases: Oracle 12C/11g/10g, MS SQL Server 2008/2005/2000 , MS Access, IBM, DB2,Teradata15.0/14.0,Netezaa.

DataModeling: Data Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

DB Tools: TOAD, SQLDeveloper,SQL Assistant, Visio, ERWIN, Tivoli Job Scheduler, Control-M, Tidal.

Languages: C, C++, Java, SQL, PL/SQL, Unix Shell Scripting

Operating Systems: UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS

ETL Tools: InformaticaPower Center 10.1/9.6/9.5/8.6/8.1/7.1 , Metadata Manager,IDQ,SSIS,DataStage.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Informatica/ETL Developer

Responsibilities:

• Installation and configuration of Power center Repository service, Integration service.
• Worked on Informatica Power Center tool - Source Analyser, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts, Upgraded Informatica from 10.1.0 to 10.2.0.
• Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Extensive experience in designing of custom objects, custom fields, and role-based page layouts, picklist, validation rules, Workflows, Mappings, Sessions using Informatica Power center 10.2.
• Develop end to end test case scenarios and write complex SQL queries to analyze any data issues or code issues.
• Perform regression testing across systems to make sure the existing code is intact.
• Automate the code by modifying into Batch jobs and schedule it weekly, daily, monthly based on the frequency the business would need the file using Tidal Scheduler.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Done LDAP configuration and synced users from the external active directory.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Developed Error Handling mechanism in Informatica using Lookup, Expression, Normalizer and Filter transformations by generating Error Codes and Error Messages for various error scenarios and passed clean data into the next level.
• Involved in preparing high-level design, testing and ETL Mapping Specification documents
• Involved in developing test plan cases, documented test cases and test plan queries for all the tables involved. Also, involved in preparing migration checklists in a timely manner meeting conversion schedules for effective cut-overs.

Environment: Informatica Power Center 10.1/10.2, Wherescape, Oracle, SQL server, Agile, Teradata, DB2, MVS, SQL, Netezza, PL/SQL, Toad, SQL Loader, UNIX, Flat files.

Confidential, Chicago, IL

Informatica/ETL Developer

Responsibilities:

• Worked inAgile development methodology environment and Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in theinstallationand configuration of Informatica Power Center 10.1andevaluated Partition concepts inPower Center 10.1
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created stored procedures, views, user defined functions and common table expressions.
• Generatedunderlying data for the reportsthroughSSISexportedcleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Workedon Informatica cloudfor creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica CloudService tasks by utilizing InformaticaCloudIntegration.
• Involved inData integration,monitoring,auditingusing Informatica CloudDesigner.
• Worked on Data Synchronization and Data Replicationin Informatica cloud.
• WrittenPL/SQLscripts,createdstored procedures and functions and debuggedthem.
• Created Mapplets, reusable transformations and used them in different mappings.Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loadsandDeveloped reports based on issues related to the data warehouse.
• Createdprofiles, rules, scorecards for data profiling and quality usingIDQ.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and Resolved the production support tickets using remedy.
• Developed monitoring scripts inUNIXand moved DataFiles to another server by using SCP on UNIX platform.
• Extensively usedTeradataUtilities likeFast-Load, Multi-Load, BTEQ & Fast-Export.
• CreatedTeradata External loaderconnections such asM Load, Upsert and Update, Fast loadwhile loading data into the target tables in Teradata Database.
• Involved creating the tables inTeradataand setting up the various environments likeDEV,SIT,UATand PROD.

Environment: Informatica Power Center 10.1, Oracle12C, Informatica Cloud, IDS 9.6.1, IDQ 9.6.1 Teradata 14.0, SQL Server 2014, Teradata Data Mover, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, SSIS, Power Connect, DB2, Business Objects XI3.5.

Confidential

Informatica Administrator

Responsibilities:

• Configured Load balancing and Grid in Informatica.
• Creation and maintenance of Informatica users and privileges.
• Created Native Groups, Native Users, roles, and privileges and assigned them to each user group.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Involved in System Documentation of Dataflow and methodology.
• Installation and configuration of B2B DX, MFT and troubleshoot the issues.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the Power Center.
• Written pre session and post session scripts in mappings.
• Created deployment groups and assigned the permissions to the deployment group.
• Created Informatica Folders and assigning the permissions to the Folders.
• Created OS profiles for the user, which used to run the applications.
• Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments.
• Coordinated with UNIX and Database Administrators for creating OS profiles and file systems.
• Handled outages when there is any maintenance in UNIX and DATA BASE.
• Collaboratively worked with Application Support Team, Network, Database Teams, and UNIX teams.
• Bouncing Activities or Restarting the Service in Network Changes or in any maintenance and Communicating to Business.

Environment: Informatica powercenter, Oracle 11.2.0.3.0, Linux and OS.

Confidential

Datawarehouse Consultant

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business units in order to define the requirements
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Developed data Mappings between source systems and warehouse components.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica PowerCenter Server.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Perform analysis and resolution of Help Desk Tickets and maintenance for assigned applications.

Environment: Informatica PowerMart, Oracle, PL/SQL, Windows, Remedy, Synergy.