PROFESSIONAL SUMMARY:

• 8 years of IT experience with OLTP, OLAP Data Warehousing and Business Intelligence experience using Informatica Power Center.
• Designed mappings using B2B data transformation studio to transform unstructured data to structured forms.
• Strong experience in activities related to the development, implementation and support of ETL processes for large - scale data warehouses using Informatica Power Center.
• Good exposure to Informatica MDM where data cleansing, De-duping and address correction were performed.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse/Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Built staging area for loading data from multiple sources and used Informatica IDQ for profiling and cleansing data.
• Experienced in integration of various data sources like Flat files, mainframe - VSAM files and XML with multiple relational data sources.
• Experienced in building ETL data flows that works natively on HADOOP.
• Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake and SCD.
• Ability to successfully work within multiple requirements, design, and development approaches and methodologies and the teams spread across multiple locations.
• Designed, implemented and migrated complex Business Objects reports.
• Created Classes, subclasses, objects, conditions, contexts, prompts and Aliases for resolving loops and checked the integrity of the universe.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications; Development and Testing as per the SDLC waterfall methodology.
• Extensive experience in implementing data warehouse for various domains like financial, insurance, and healthcare.
• Experienced in Conceptual, Logical and Physical design of relational databases.
• Good exposure to SQL, PL/SQL and ORACLE.
• Participated in multiple big data POC to evaluate different tools and vendor products.
• Effective team player who enjoys learning new technologies, methods and putting them into daily practice.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center9.x/8.x/7.x, Informatica Power Exchange, B2B Data Transformation, Informatica IDQ and SSIS.

Reporting Tools: Business Objects, Actuate.

Web Technology: HTML, DHTML

Data Bases & Tools: Oracle 8i /9i,11g, MS-SQL Server 2005/2008/2012 , TOAD, SQL DEVELOPER

Languages: SQL, PL/SQL.

Platforms: UNIX, Windows9x/NT, Windows 2000/2003 Server.

PROFESSIONAL EXPERIENCE:

Confidential, Chapel Hill, NC

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Users and Managers in Gathering Business requirements.
• Analyzed the existing process for product specific and design for enhancements.
• Parsed high-level specifications to simple ETL coding and mapping standards.
• Involved in Dimensional modelling (start schema) of the data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Designed mappings using B2B data transformation studio to transform unstructured data to structured forms.
• Built staging area for loading data from multiple sources and used Informatica IDQ for profiling and cleansing data.
• Resolved Inconsistent and Duplicate data to support strategic goals with multi domain MDM.
• Prepared Design and Mapping specifications for the ETL process based on Functional specifications.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed complex mappings such as Slowly Changing Dimensions Type II- time stamping in the mapping designer.
• Developed mappings using Informatica Power Center/ Power Exchange Designer to transform and load the data from source systems to Staging and Staging to target database.
• Attended to Change Requests and Issues in existing frameworks.
• Performance tuning of long running Informatica jobs and SQL queries.
• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Created sessions, configured workflows to extract data from various sources, transformed data and loaded into data warehouse.
• Prepared the required application design documents based on functionality required.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using SQL Procedures for populating the desired.
• Used UNIX shell scripts to automate pre-session and post-session processes.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems according to the user requirements.

Environment: Informatica power center 9.5, Informatica Power Exchange, B2B Data Transformation SQL Server 2008, Oracle 11g, MS Excel, PowerPoint, Word, MS-SQL Server, Toad, HP Quality Center

Confidential, New York City, NY

Informatica Developer

Responsibilities:

• Developed complex mappings in Informatica to load data from various sources.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run the objects in different environment.
• Checked sessions and error logs to troubleshoot problems and also used debugger for complex problem trouble shooting.
• Wrote Oracle PL/SQL procedures and functions based on business needs.
• Provided knowledge transfers to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of mappings.
• Analyzed the business requirements and functional specifications.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, SQL Server 2008, ORACLE, MS Excel, PowerPoint, Word, Windows XP,Toad

Confidential, Rochester, NY

Informatica Developer

Responsibilities:

• Performed data extraction from various sources using Informatica 8.6.
• Used Informatica Designer to create complex mappings, transformations, source and target tables.
• Experience in Performance tuning of Sessions, Mappings, sources, Targets and Transformations.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Performed Type1 and Type2 mappings.
• Created Mapplet and used them in different Mappings.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.

Environment: Informatica power center 8.6, SQL Server 2008, MS Excel, PowerPoint, Word, Windows XP, HP Quality Center

Confidential

Informatica Developer

Responsibilities:

• Performed data extraction from various sources using Informatica tool.
• Used various transformations like Source Qualifier, Joiner, Lookup, Router, Filter and Update strategy.
• Involved in Data cleansing for data consistency whether the data source is a single system or multiple sources.
• Tuned Informatica mappings for optimal load performance.
• Created and configured workflows and sessions to transport the data to target Data warehouse using workflow manager.

Environment: Informatica power center 8.0, SQL Server 2008, MS Excel, PowerPoint, Word, SQL Server, Business Objects, Oracle

Confidential

Responsibilities:

• Contributed software engineering expertise in the development of products through the software lifecycle, from requirements definition through successful deployment.
• Facilitated customization of systems by encouraging software engineering team to adopt emerging standards for software application development architecture and tools.
• Participated in sales presentations due to ability to translate user needs into easy-to-understand software solutions. Helped sales team close five major deals generating more than $150K in revenue.
• Excelled in rapid application development and management of technological issues for assigned projects, earning the highest customer satisfaction rating for all software solutions delivered.
• Introduced methodologies and best practices that enhanced product definition, release processes and customization of applications to user needs.
• Creation of schema objects including tables, indexes, stored procedures, functions
• Load test data using bulk data loading tools (SQL Loader).
• Implement business logic through SQL queries and procedures/functions.
• Analyzed the current table structure.
• Analyzed and created stored procedures and functions to integrate data from various sources to tables.

Environment: Informatica power center 8.0, SQL Server 2005, MS Excel, PowerPoint, Word, Windows XP.