PROFESSIONAL SUMMARY:

• 6 Years of experience in Data Warehousing, Analysis Design, Development, Testing, Implementations and maintenance of Business Intelligence, and other related Database Platforms.
• 6 Years of extensive experience in working with Informatica power center with various versions of 9.1/9.5 /9.6/10.2.
• Proficient in end to end Software Development Life Cycle and excellent with agile methodology.
• Have worked extensively on data extraction from relational tables and flat files using Informatica.
• Have worked extensively on unit and integration testing of Informatica mappings, and documenting the same.
• Have proficiency in understanding the user/business requirements, and converting the same into Informatica mappings and workflows.
• Have traced many production failures in the production data and provided solution for them.
• Involved in various phases of the BI projects like preparing estimates, preparing technical specifications, end to end testing, ETL development...etc.
• Hands on Experience in the implementation of various Transformations logic in Mappings.
• Hands on Experience in creating the Business objects reports that displays source to target. counts or measures information of the ETL.
• Created various transformations like Source Qualifier, Connected and Unconnected Lookup, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy etc.
• Built reports to protect row level security, meaning restriction of data visibility to a set of users, using user groups & users.
• Solid understanding of SQL and worked with various data source types like Oracle and SQL Server.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows 10, UNIX

Languages: C, Core Java, HTML, SQL

Databases: Oracle 11g/10g, SQL Servers

Reporting Tool: Business Objects

ERP Skill: Informatica 10.2/9.6.1/9.5.1/9.1

PROFESSIONAL EXPERIENCE:

Confidential, Minnetonka, MN

Informatica developer

Responsibilities:

• Responsible for Business Analysis and Requirements Gathering.
• Coordinated with cross - functional teams in different locations for quality data and based on the Mapping Specifications, developed the mappings based on the requirements.
• Designed complex mappings using various transformations like source qualifier, router, Expression, filter, union, sorter, aggregator, update strategy, sequence generator, rank, Look Up (connected and unconnected).
• Involved in development phase and created mappings.
• Involved in code reviews and source/target mapping.
• Involved in Unit testing, Integration testing, and code reviews.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively optimized the performance of existing and new mappings using various performance tuning techniques.
• Worked with QA team in case of any defects raised and resolving those defects.
• Extensively used Autosys to schedule the Informatica jobs in different environments using job definitions and job chains.

Environment: Informatica 10.2, Oracle, Autosys, Windows 10.

Confidential, Eagan, MN

Informatica developer

Responsibilities:

• Responsible for Business Analysis and Requirements Gathering.
• Translated requirements into business rules and made recommendations for Application Warehouse Development.
• Coordinating with cross-functional teams in different locations for quality data.
• Prepared high-level design, technical specification, source-target mapping documents by gathering Business requirements.
• Designed complex mappings using various transformations like router, source qualifier, and application source qualifier, Expression, filter, union, normalizer, aggregator, update strategy, rank, Look Up and other transformations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Created mapplets for reusable code and used them in various mappings.
• Involved in Unit testing, Integration testing, and code reviews.
• Extensively optimized the performance of existing and new mappings using various performance tuning techniques.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Extensively used Autosys to schedule the Informatica jobs in different environments.

Environment: Informatica 9.6.1, Oracle, Autosys, Windows 10.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Used Informatica file watch events to pole the FTP sites for the external files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 9.6.1, Oracle, AutoSys, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Participated in client requirements gathering, analysis and documentation.
• Development of mappings as per technical specifications approved by the data warehouse architects.
• Worked extensively on Informatica Power Center Designer, Workflow Manager, Monitor and Repository Manager.
• Worked on various types of transformations such as Expression, Joiner, Update Strategy, Aggregator, Filter, Lookup and Router etc.
• Proficiently handled Slowly Changing Dimensions (type - 2) and change data capture techniques.
• Used Mapping Parameters and Variables for code reusability and eliminate hard-coding; this reduced the development time in many cases.
• Created reusable Transformations and Mapplets for use in multiple Mappings and reduce development time as well as increase maintainability.
• Involved in the debugging of mappings by creating break-points using the Debugger tool to troubleshoot ETL logic.
• Prepared UTP (Unit Test Plan) documents with all required validations and test cases to cover various scenarios. Performed Unit, Integration and System Testing in consultation with the data architects and testing team.
• Worked on dimensional modeling, data cleansing and data staging of operational sources using ETL processes.
• Created Sessions, Worklets and Workflows to run with the logic embedded in the mappings using PowerCenter Designer.
• Used Workflow Manager for session creation/management, database connection management and scheduling of jobs.
• Involved in performance tuning of various Informatica objects such as transformations, sessions, sources and targets etc.

Environment: Informatica PowerCenter 9.1, Oracle 10g, Windows.