SUMMARY:

• Around 8.5 years of experience in Development, Enhancement, Maintenance, Production support, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses for Insurance domain.
• Currently working as System Analyst in Confidential Technology Solutions. As a system analyst I got good appreciation from clients for taking care of unforeseen complex issues and delivering the project on time with quality deliverables.
• Strong in analyzing, developing, problem solving and decision - making abilities in Data Warehouse using Informatica Power Center 9.6.1
• Experience and knowledge in data extraction, data transformation and data loading (ETL). Good knowledge on data warehousing concepts likes star schema, snowflake schema.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows.
• Experience in software development in Oracle SQL, PL/SQL, SQL SERVER. Teradata
• Expertise in creating synchronization tasks in the Informatica Cloud.
• Experience in creating Inbound and outbound task in the Informatica Cloud and Salesforce.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Automation, Scheduling and monitoring of jobs with scheduler Control-M.
• Exposure writing complex SQL Queries.

SOFTWARE SKILLS:

Operating System: XP, 2003, Windows 7

Languages: PLSQL, SQL, Unix shell Scripting

RDBMS: Oracle 11G, SQL Server

Domain Knowledge: General Banking, Insurance, Maintenance

Developer Tools: PLSQL Developer, Informatica Power center 9.6.1, Informatica Cloud, control-M, Putty,Data Loader

Database: SQL server 2008,2012

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

ETL Tools: Informatica 9.6.1

Cloud Tools: Informatica Intelligent Cloud Services

DBMS: Sql Server 2012

Operating System: Windows 7

Responsibilities:

• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Update the status and plan the releases through the scrum meetings.
• Coordinating with offshore team and providing the inputs.
• Developing the ETL detail design documents for each target tables (Fact and dimension tables).
• Creating primary objects (tables, views, indexes) required for the application.
• Designed and developed complex mapping for varied transformation logic like Expression, Filter, Aggregator, Router, Joiner Update Strategy, Unconnected and Connected lookups
• Used Informatica Debugger to troubleshoot logical errors and runtime errors.
• Performed the tuning at source, Target and informatica mappings using Indexes, and Partitioning in SQL Server, Oracle and Informatica.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Creating the deployment documents and migrating the code to the production environment.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Scheduling the jobs in Control M.
• Updating the Project health status in JIRA and Weekly status report.

Confidential

ETL Developer

ETL Tools: Informatica 9.6.1

DBMS: Sql Server 2012

Operating System: Windows 7

Responsibilities:

• Closely worked with business users and business analyst to understand the business requirements.
• Worked with data modeler to design dimensional model that fits best to the requirements.
• Prepared the high level design.
• Created Informatica mappings to load data from different source like ODS, Fiserv, SWAP, CSI to Data warehousing and Data mart.
• Designed and developed the mapping which generates the parameter file dynamically.
• Prepared the Unit Test Cases and tested the same.
• Worked on ETL code elevation from Dev to QA/Test/Acceptance.
• Extensively involved in fine tuning of mappings and sessions for better performance and through put.
• Scheduled the jobs in Control M

Confidential

ETL Developer

ETL Tools: Informatica power center 9.6.1, Power Exchange

RDBMS: Teradata 14 and Oracle 11g, PL/SQL Developer

Operating System: Windows 7

Responsibilities:

• Understanding the Specification document completely and implements data transformation methodologies.
• Developed Informatica mappings to load the data from various sources using different transformations based on the requirement.
• Involved in designing the E.T.L mapping documents.
• Involved in preparation of Design Documents (DD).

Confidential

ETL Application Developer

ETL Tools: Informatica 9.0

RDBMS: Oracle 11g, PL/SQL Developer

Operating System: Windows XP, Linux

Analytical Tools: Confidential DecisionWorks, Confidential Enterprise Analytics

Responsibilities:

• Understanding the Business requirement document (BRD) and Data mapping document (DMD) completely and implements data transformation methodologies.
• Loading CSV, fixed length files (TP) data to ETL tables using Informatica.
• Using Data mapping document, Implements Business logic to ETL tables.
• Extracting, Transforming and Loading the data from Source to ETL tables and UDS, UDB tables.
• Developed Informatica mappings to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy and Router transformations.
• Involved in designing the E.T.L mapping documents.
• Involved in preparation of Technical Design Documents (TDD).
• Working on various tasks like Shell Scripting, Session Task and Event Wait.
• Scheduled job using Workflow Scheduler.