SUMMARY:

• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center, IDQ.
• Proficient in understanding business processes / requirements and translating them into Technical requirements.
• Proficient level working on Creating ETL Documentation as per Business Specifications.
• Experience in using transformations in Informatica Power center and Data Quality.
• Experience in Analyzing data and creating Data Model as per data flow using the reference data with the reference of Data Dictionary.
• Experience in Creating Control Frame Work (CFW) and ETL Exception Design. Experience in Building framework using Informatica to dynamically generate queries by reading metadata.
• Experience in analysis, design, development, customization, implementation and testing in Informatica Mappings.
• Hands on experience in identifying and resolving bottlenecks in various levels like sources, targets, mappings and sessions.
• Worked extensively on Error Handling, Performance Analysis and Performance Tuning of Informatica ETL Components and SQL Scripts.
• Have performed various testing activities like unit testing, Integration - system Testing and user acceptance testing and ensured that the code is ideal.
• Experience with UNIX Shell Scripting on UNIX & Linux platform.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center v9.6, v9.5, v9.1, v8.6, Informatica Data Quality v9.6, v9.5, DVO (Data Validation Option), MDM v9.6

Database Platforms: SQL Server 2008/2012/2014, Oracle 10g/11g/12g, Teradata V2R12/V2R6, DB2

Programming/Languages: SQL, PL/SQL Scripting, UNIX Shell Scripting

Operating Systems: Windows 2003/XP/7, Vista, UNIX (Sun Solaris and Linux)

SDLC Methodologies: Agile/Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr.Informatica Developer

Roles & Responsibilities:

• Coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document
• Analysis Investment Data Load in to the data warehouse for creating reports for business using Informatica power center.
• Using Informatica Increased accuracy of business analysis and financial reporting.
• Develop Control Framework (CFW) is a framework to schedule ETL job dependencies, track and monitor ETL batches, control execution flow and provide ETL batch run statuses Maintain ETL Exception as per business Specifications.
• Worked on Fund, Security and Transactions data.
• Working on eliminating single points of failure across the platform for high availability.
• Maintain ETL Exception as per business Specification.
• Test the mappings and fixed the bugs as per QA bugs and working on Unit testing.
• Involved in Informatica Code Migration across various Environments

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1, Informatica DVO (Data Validation Option), SQL, PL/SQL, Oracle 11g, Teradata, DB2, Toad, SQL Assistant, Flat files, XML Files, Agile/Scrum, UNIX

Informatica Developer

Roles & Responsibilities:

• Implemented Informatica to help consolidate data and improve its quality, establish consistent business processes and create a single source of business information across the enterprise.
• Coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document.
• Migrated business data from five systems to a single platform, creating more tightly integrated business processes.
• Based on requirements, developed Source-To-Target mapping document with business rules and also developed ETL Spec documentation.
• Experience in using the Informatica Utilities like Pushdown optimization and Session Partitioning to improve the performance of Informatica mappings.
• Working on load the data into effective consolidation of data warehouses, which provide easier access to business intelligence and help streamline reporting.
• Created consistent product and customer data across business units.

Environment: Informatica Data Quality 9.6.1, Informatica Power Center 9.6.1, SQL, PL/SQL, Oracle 11g, Teradata, DB2, XML File, Toad, SQL Assistant, Flat files, UNIX

ETL Developer

Roles & Responsibilities:

• As per Business needs like quality of its retail reporting tracked which products retailers ordered, when they were ordered and shipped. And track or forecast actual sales.
• Integrate wholesale and inventory data with POS data Using Data Integration tool Informatica to help drive key business decisions
• Design the physical model and ETL Design for integrating data from current systems.
• Working on cleaning and performance issues to deliver data for reporting.
• Developed Mappings, Sessions and Workflows to extract, validate, and transform data according to the business rules.
• Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 9.x, IDQ, Oracle 11g, DB2, SQL Server 2008, Teradata V2R6, UNIX.

Informatica Developer | IDQ Developer

Roles & Responsibilities:

• Working on provide utilization data confidentially and securely to both the federal and state governments for regulatory compliance purposes.
• Working on migrate health care data safely from legacy systems to a new infrastructure.
• Working on Medicare and Medicaid payment system requirements.
• Analyzed the technical requirements and data flows and prepared technical strategy documents.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Data Profiling, Parses, cleanses, verifies & standardizes global address using IDQ and integrating with the Informatica suite of tools. Worked on IDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate data quality by creating cleanse processes to monitor compliance with standards and assist in resolving data quality issues.

Environment: Informatica Power Center 9.x, IDE/IDQ, DVO, SQL, Oracle 11g, Teradata, UNIX

Informatica Developer

Roles & Responsibilities:

• Create unified platform that connects all of the Industry information and delivers accurate, shared and trusted information throughout the business.
• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling, which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.

Environment: Informatica Power Center 9.x/8.x, Oracle 10g, TOAD, UNIX