SUMMARY:

• Software engineering professional with 4 years of experience in full life cycle software development requirements analysis, design, coding, testing, documentation, and Implementation of Business Intelligence solutions using Data warehousing tools.
• Well conversant with the Data Warehousing & Data Modeling methodologies.
• Extensive work experience in Informatica with good domain knowledge on Insurance, Energy and Aviation clients.
• Experience in ETL operations to load data from different sources systems such as RDBMS, Flat Files, XML Source, Oracle, MS SQL Server, Netezza and Excel Files into Data warehouse and Data marts using Informatica Power Center 10.0.1/9.5/9.1.
• Created mappings with complex XML files, Used XML, XSD’s as Source and XML Transformations in ETL mappings.
• Knowledge in Informatica Data Quality (IDQ) tool.
• Certified Informatica PowerCenter Data Integration 10: Developer, Specialist Certification
• Comprehensive Knowledge of RDBMS.
• Good working experience with Waterfall & Agile Methodology.
• Knowledge of Salesforce Application, Sales force Data Base, SOQL and Informatica Integration with Sales force application.
• Knowledge of Informatica Integration with SAP, created mappings using SAP IDOC
• Performance Tuning of reports, mappings and SQL queries.
• Experience in using Automation Scheduling tools like Tivoli.
• Have worked on Windows and UNIX operating systems and a fair knowledge of Linux operating systems.
• Knowledge in OLAP, OLTP processes and synchronize Mainframe data with corporate IT environment.
• Provided production support during weekends. Implemented migration and change tickets in production.
• Worked in Data analysis to perform on - going data validation, data consolidation, data cleansing, and data maintenance.
• Sound interpersonal skills highlighting an ability to explain complex technical issues.
• Ability to communicate with users at all levels and inform them as to the most efficient use of information systems.
• Self- starter and ability to work with limited supervision.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.x, 9.x, Informatica Developer

OS: Windows, UNIX

Programming: SQL,PL/SQL, Shell Scripting

Database Tools: TOAD, SQL Navigator, SQL Developer, SQL server 2012

Database: RDBMS, My SQL Server, Oracle 11g/10g, Netezza

Modelling tools: Erwin

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, Branchville, NJ

Roles & Responsibilities:

• Working in Agile team with Product owners, BI Analytics team for the Requirement Specifications.
• Development of mappings, sessions, workflows using Informatica Power Center 9.6.1.
• Created new SCD-1/SCD-2 Mappings using Transformations like Expression, Joiner, Union, XML Parser, SQL, Aggregator, Connected & unconnected lookup, Filter, Sequence generator, Router, Sorter, Update Strategy.
• Preparing test plan, test cases and testing of data and code
• Defines data quality rules using IDQ 9.6.1 and ensures the proper implementation of data quality during the creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
• Catalog, track, and ensure remediation for known data quality issues.
• Working extensively on RDBMS systems.
• Writes complex SQL Queries against SQL Server including analyzing and troubleshooting SQL statements, code and modeling database objects.
• Performance Tuning and Data Processing.
• Perform development of Conceptual, Logical and Physical Data Models and participate in Data profiling activities on the source systems with BI Architect.
• Coordinating with offshore team along with work distribution.
• Production support during weekends on rotational basis.
• Meeting with Business Analysts and Data Modelers for issues and clarifications.
• Performance testing based on Integration and system test plans and supports UAT in order to ensure defect free program/modules/system/infrastructure release.
• Participate in KT sessions, prepare and review system appreciation documents, understand application/system/infrastructure dependencies, perform shadow support in order to complete transition.

Tools &Technology Used: Informatica Power Center 10.0.1, 9.6.1, RDBMS, MS SQL Server, Netezza, SQL, PL/SQL, Windows Scripting.

Informatica Developer

Confidential

Roles & Responsibilities:

• Participate in requirements analysis meetings with Data Analysts & users to understand requirements.
• Analyze and change existing mappings as per the logic mentioned in the mapping document.
• Implemented the projects in Agile Methodology and used tools like JIRA for user stories tracking.
• Worked in implementation of Different Integrations for HUD (Home Owner, Umbrella and Dwelling) project with Guidewire application.
• Created mappings with complex XML files from Guidewire policy center application and loaded data for Reporting.
• Created mapping with XML Parser transformation to parse the application data and load into DWH tables.
• Tuned ETL process by analyzing target and source bottlenecks.
• Used Labeler, Standardizer, Address Validator transformations to create IDQ mappings for address cleansing. Also created profiling objects.
• Involved in migrating the Mappings, Sessions, Workflows from DEV environment to QA and UAT environment.
• Have written windows batch scripts to execute the workflows and raised requests to schedule it in Tivoli Work load scheduler.
• Created mappings to create parameter files and reusable cache.
• Coordinated with offshore team and distributed work among the team members.
• Preparing test plan, test cases and testing of data and code.
• Participated in Unit Testing, Integration Testing and Spot Checking of data.
• Used Quality Center to keep track of issues and track the progress of the development of projects
• Preparing design documents and providing KT and guiding other resources.

Tools &Technology Used: Informatica Power Center 9.5.1, RDBMS, MS SQL Server, Oracle, UNIX Shell Scripting.

Informatica Developer

Confidential

Roles & Responsibilities:

• Requirement Analysis of different source systems.
• Create High Level Design Document and reviewed with Architects & Data Analysts.
• Designed and Developed ETL Informatica Mappings.
• Worked in supporting application providing required data.
• Created mappings to create parameter files and reusable cache. Also created mappings to clear the cache files.
• Tuned ETL process by analyzing target and source bottlenecks. Also used pushdown optimization & Dynamic partitions.
• Created production migration documents with necessary information like DDL changes, Workflows, scripts and scheduling information.
• Extensively used Designer, Workflow manager and Monitor for creating, executing and monitoring workflows.
• Prepared the Unit and Integration test cases and helped the users in UAT testing.
• Prepared the documents for Production migration and provided post production support.

Tools &Technology Used: Informatica Power Center 9.1, Oracle, UNIX Shell Scripting