SUMMARY:

• 8+ years of experience in Data Warehousing/Integration using ETLTool InformaticaPower Center 9.5.6/8.6.1/7.1.2 across the business areas such as Healthcare and Banking
• Extensive experience in using Informatica Power Center to carry out the Extraction, Transformation and Loading process
• Create clear and concise epics/stories using JIRA as tracking tool.
• Extensive experience with ETL/SSIS tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, and scheduling the Workflows and sessions. Extensive experience in Workflow Manager and Workflow Monitor and scheduling ETL/SSIS jobs in Informatica.
• Worked with Informatica Data Quality 9.x (IDQ) Developer for data cleansing, data matching, data conversion, exception handling and monitoring capabilities.
• Experienced in integration of various data sources like Oracle 11g/10g, MS SQL Server 2012/2008 and Flat Files into staging area.
• Created High level, low level design documents, ETL/SSIS specification documents,Data modeldocumentand test casesdocument.Responsible for creating/quantifying Agile epics, stories and assigned tasks for the team on RTC.
• Slowly Changing Dimensions Management including Type 1, 2, 3, Hybrid Type 3, De - normalization, Cleansing, Conversion, Aggregation, Performance Optimization
• Worked on non-relational sources like Flat Files and used secure FTP.
• Worked on Oracle PL/SQL programming, Stored Procedures, Creating Triggers and Sequence Generator on the Target Table.
• Building a proof-of-concept stand-alone scheduler using AngularJS. Assisting in the implementation of JIRA, logging epics, stories and assigning tasks.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files, Netezza into a staging area.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office
• Expert in writing SQL, PL/SQL Stored procedures using Toad. Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, Fast Export, SQL Assistant, T-PUMP.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation .
• Excellent hands-on MDM, IDQ, Data Transformation.
• Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.
• Experience in developing Informatica Reusable components for using them across the projects.
• Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
• Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling..
• Hands on experience in resolving the production issues in 24/7 environment.
• Proficient in creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams;Epics and User stories.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools
• Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5.6/9.5.1/9.1.0/8.6.1/8.5.1/7.1.2

Data Modeling: Dimensional Data Modeling, ETL/SSIS, EPICS, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle 11g,10g/9i/8i, Teradata v14/15, MS SQL Server 2008/2005, DB2, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Netezza, SQL*plus, Mongo DB, Data Management tool.

Programming: Java, C, C++, XML, HTML, Java Script, JSP, UNIX Shell Scripting, SQL, PL/SQL, Batch Scripting.

Environment: UNIX, Windows XP/Vista, Linux, Windows 2007 Professional

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL/Informatica Developer

• Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation etc.
• Learned the company’s EDW architecture which consists of sources, middleware, staging area, data warehouse, and reporting tools.
• Implemented Exception Handling Mappings by using Data Quality, data validation by using Informatica Analyst.
• Proficient in creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams;Epics and User stories.
• Proficient in Informatica Data Quality (IDQ) 9.6.0.
• Experienced in Bad Record Exception management using IDQ rules and workflows
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. DocumentedEpics, Features andUser Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Created mappings in Informatica Developer (IDQ) using Parser, Standardizer and Labeler, Exception, Merge Transformations.
• Interacted with business analyst, ETL team lead, and data base admin to gather information and to collect business requirements to develop Informatica Mappings.
• Implemented Change Data Capture using Informatica Power Exchange 9.1.
• Designed, developed Informatica Power Center 9.5 mappings to extract, transform and load the data into Oracle 11g target tables.
• Designed faster to market technical solutions and Lead as Architect by collaborating with interfacing teams to define the POA and PON from the EPICS, in order to finalize release scope.
• Extensively worked on Informatica tools like source analyzer, mapping designer, workflow manager, workflow monitor, mapplets, worklets and repository manager.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Created test cases and completed unit, integration and system tests for Data warehouse.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Uses Teradata SQL Assistant to develop queries and access data base objects
• Develops Teradata BTEQ scripts to populate target tables.
• Develops SQL scripts and ad-hoc queries for data verification during Unit Testing phase of the SDLC.
• Closely moved with the Micro strategy reporting team and helped them to get the data for creating report.
• Worked on agile methodology.
• Prepared an ETL technical document maintaining the naming standards.
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source Definitions, Target definitions and imported them to other environments.

Environment: Informatica PowerCenter 9.5, Informatica Power Exchange 9.1, Informatica IDQ 9.6,Informatica Analyst, IDD/BDD, Oracle 11g, PL/SQL, SQL, Flat Files, TOAD, Teradata 14.Unix, SQL Server 2012.

Confidential, Hopkins, MN

ETL/Informatica Developer

• Worked with end users to understand the Business Requirements, Designing the Workflow, Implementing and Supporting on ongoing basis.
• Expert in writing SQL, PL/SQL Stored procedures using Toad. Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, Fast Export, SQL Assistant, T-PUMP.
• Experienced on writing SQL statements and analyzing SQL performance.
• Ability to work in teams.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Planned, created, and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Loaded data to the interface tables in oracle from multiple data sources using informatica.
• Implemented Aggregator, Filter, Joiner, Expression, Lookup, Normalizer and Update Strategy transformations.
• Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.
• Implemented variables and parameters in transformations to calculate billing data. customizing/configuring Business Data director (BDD)/Informatica data director (IDD)applications.
• Created sessions, sequential and concurrent batches for the mappings using Workflow Manager.
• Writing stored procedures, functions and packages to implement business logic
• Worked on different utilities of Teradata like fast load, M-load, T-pump and Fast export.
• Developing, executing & monitoring Autosys (Process Scheduler) jobs.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices.

Environment: Informatica PowerCenter 9.1, Flat Files, Autosys, Informatica Multi-domain MDM 9.7.1, HP ALM (Application Lifecycle Management), Win SCP, Teradata v13, MongoDB.

Confidential

ETL/Informatica Developer

• Analyzed functional specification documents and worked closely with the various application teams and functional teams to design Technical specification documents.
• Studied the data requirements and the impact analysis on the existing schema.
• Participated in the review meetings with functional team to signoff the Technical design document.
• Written Unix Shell Scripts to schedule the informatica jobs using PMCMD command.
• Created various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter.
• Designed reusable transformations and mapplets.
• Mapped the source and target databases by studying the specifications and analyzing the required Business logic.
• Responsible for optimizing the ETL mappings and monitoring the load process in order to check the data.
• Involved in identifying surrogate keys for the fact table.
• Defined data definitions, and created target tables in the database.
• Written PL/SQL Procedures, Function and Packages to perform database operations and pre & post session commands.
• Prepared User documentation to train users and functionality of each report.

Environment: Informatica PowerCenter 8.6.0, Oracle 10g, PL/SQL, Toad, UNIX, HP Quality Control, Service Now.

Confidential

ETL Developer

• Developed ETL procedures that is consistent across all application and systems.
• Created Folders using Informatica PowerCenter Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• Worked on Informatica tools like Source Analyzer, Target Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed and modified complex SQL Queries and Stored Procedures as per business requirements.
• Performed tuning of sessions in Target, Source, Mappings and Session areas.
• Normalized the tables to minimize redundancy and dependency.
• Created Indexes to speed up the queries.
• Creating Technical Specifications and Mapping Documents.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL, Jira, LINUX/UNIX.