SUMMARY

• Experienced in Development, Migration, Enhancement, Testing and Production Support Projects of Data warehousing projects using Informatica as ETL tool.
• Over 15+ years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications.
• Excellent domain knowledge of Shipping, Logistics, Consolidation, Claims and Food Service..
• 7 years of Strong expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.2 (Designer, Workflow Manager, Repository Manager, and ETL concepts.
• Extensive experience wif Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Oracle, SQL SERVER, DB2), VSAM and Flat Files
• Worked wif various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, JAVA, Union, CDC etc.,
• Designing and developing Informatica mappings including Type - I, Type-II, Type-III slowly changing dimensions (SCD).
• Experienced in using advanced concepts of Informatica like push down optimization (PDO).
• Very good in data modeling knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Certified in project management skills
• Experienced in coordinating wif Business Users, functional Design team and testing team during teh different phases of project development and resolving teh issues.
• Good skills in defining standards, methodologies and performing technical design reviews.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Fixing Informatica code to resolve Business critical errors and deploying teh code in production
• Extensive experience in Production support which does not limit not only to monitoring teh Batch jobs, tracking and resolving teh incidents and provided solutions on time to teh application users but also quick turnaround fixes
• Experienced in finding teh root cause for Batch Job failures, reviewing Logs, Health Checks by coordinating wif teh respective teams.
• Experience in scheduling teh batch jobs using Informatica scheduling & Workflow Monitor.
• Monitoring teh performance of production data loads and initiating action plans to tune teh long running data loads.

TECHNICAL SKILLS

Tools: Power Center 8.x/9.x/10.x, MS Project, Jira, Microsoft Visio, Visual Studio, TOAD, MS Office, Share Point, Autosys, Control-M, ServiceNow

Databases: Oracle, MS SQL Server, MS Access

Languages: PL/SQL, C#.

Internet Technology: JavaScript, JQUERY, CSS, HTML5

App & Web Server: IIS, Apache

Client / Server / Web: Oracle Forms / Oracle Reports / Oracle PL-SQL / Toad / SQL*PLUS / PSP

Version Control Tools: TFS (Team foundation Server), PVCS

PROFESSIONAL EXPERIENCE

Consultant, Tata Consulting Services

Environment: Informatica PowerCenter 10.2.x, Oracle 11g, Pl/SQL Developer, Putty, Shell Scripting, WinSCP,, SAP Business Report, Autosys, Control-M, Service Now.

Confidential, New Jersey

Responsibilities:

• Analyse business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Extensively used Pre-SQL and Post-SQL scripts for loading teh data into teh targets according to teh requirement.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested teh mappings.
• Designing and developing Informatica mappings to achieve teh desired functionality.
• Creating reusable transformations and used in teh mappings according to teh business needs.
• Preparing Test cases and test data for Unit testing.
• Initiate/Participate in Peer reviews.
• Handling communication wif teh business in teh event of load failure/system unavailability.
• Coordination between different teams like DBA, Informatica Admin, FTP teams during Load Failures and fixed teh issues wifin time line.
• Provided knowledge transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh Informatica.
• Improved teh performance related to long running jobs.
• Collaborated closely wif other developers, designers, key stakeholders, and external partners during analysis, planning, design to delivery of teh products (production release).

Environment: Informatica PowerCenter 9.6, Oracle 11g, Visio, Pl/SQL Developer, Informatica Scheduler, Putty, Shell Scripting, WinSCP, Notepad++, JIRA.

MOL Consolidation Services Data Warehouse system

Confidential, New Jersey

Responsibilities:

• Worked wif whole spectrum of application development cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Analyse business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested teh mappings.
• Designing and developing Informatica mappings to achieve teh desired functionality.
• Creating reusable transformations and used in teh mappings according to teh business needs.
• Preparing Test cases and test data for Unit testing.
• Coordination between different teams like DBA, Informatica Admin, FTP teams during Load Failures and fixed teh issues wifin time line.
• Created extensive documentation on teh design, development, implementation, daily loads and process flow of teh Informatica.
• Improved teh performance related to long running jobs.
• Collaborated closely wif other developers, designers, key stakeholders, and external partners during analysis, planning, design to delivery of teh products (production release).

Environment: Informatica PowerCenter 9.6, Oracle 11g, Visio, Pl/SQL Developer, Informatica Scheduler, Putty, Shell Scripting, FileZilla, Notepad++, JIRA

Starnet Data Warehouse system

Confidential, New Jersey

Responsibilities:

• Analyse business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested teh mappings.
• Designing and developing Informatica mappings to achieve teh desired functionality.
• Creating reusable transformations and used in teh mappings according to teh business needs.
• Preparing Test cases and test data for Unit testing.
• Coordination between different teams like DBA, Informatica Admin, FTP teams during Load Failures and fixed teh issues wifin time line.
• Created extensive documentation on teh design, development, implementation, daily loads and process flow of teh Informatica.
• Improved teh performance related to long running jobs.
• Collaborated closely wif other developers, designers and key stakeholders during analysis, planning, design to delivery of teh products (production release).

Environment: Informatica PowerCenter 8.6, Oracle 11g, Visio, Pl/SQL Developer, Informatica Scheduler, Putty, Shell Scripting, Filezilla, Notepad++

MOL Claims system

Confidential, New Jersey

Responsibilities:

• Participated in business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Designing and developing Informatica mappings to achieve teh desired functionality.
• Creating reusable transformations and used in teh mappings according to teh business needs.
• Preparing Test cases and test data for Unit testing.
• Coordination between different teams like DBA, Informatica Admin, FTP teams during Load Failures and fixed teh issues wifin time line.
• Created extensive documentation on teh design, development, implementation, daily loads and process flow of teh Informatica.
• Improved teh performance related to long running jobs.
• Collaborated closely wif other developers, designers and key stakeholders during analysis, planning, design to delivery of teh products (production release).
• Delivered multiple projects for MOL Liner Division.
• Managed a 10+ member IT team (both on-shore and off-shore) to develop and manage different features of teh MOL corporate website.
• Instrumented teh migration of corporate website from Web form to asp.net MVC and deployed it on Azure cloud.
• Managed teh development of Online Claims system to automate teh management from Incident Reporting to settlement details.