SUMMARY

• Experienced in Development, Migration, Enhancement, Testing and ProductionSupport Projects of Data warehousing projects using Informatica as ETL tool.
• Over 11 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 and Claims.
• 6+ years of Strong expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.2 (Designer, Workflow Manager, Repository Manager, Data Quality (IDQ) and ETL concepts.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Teradata, Oracle, SQL SERVER, DB2), VSAM and Flat Files
• Experience in working with master data management (MDM) and data quality (DQ).
• Worked with 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.
• Coordinating with Business Users, functional Design team and testing team during the different phases of project development and resolving the 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 the code in production
• Extensive experience in Production support which does not limit not only to monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users but also quick turnaround fixes
• Experienced in finding the root cause for Batch Job failures, reviewing Logs, Health Checks by coordinating with the respective teams.
• Experience in scheduling the batch jobs using Informatica scheduling &Workflow Monitor.
• Monitoring the performance of production data loads and initiating action plans to tune the long running data loads.

TECHNICAL SKILLS

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

Confidential

Informatica Developer

Responsibilities:

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

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

Confidential

Responsibilities:

• Worked with 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 with 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 the mappings.
• Designing and developing Informatica mappings to achieve the desired functionality.
• Creating reusable transformations and used in the mappings according to the 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 the issues within time line.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica.
• Worked on UNIX shell scripting.
• Improved the performance related to long running jobs.
• Collaborated closely with other developers, designers, key stakeholders, and external partners during analysis, planning, design to delivery of the products (production release).

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

Confidential

Responsibilities:

• Analyse business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with 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 the mappings.
• Designing and developing Informatica mappings to achieve the desired functionality.
• Creating reusable transformations and used in the mappings according to the 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 the issues within time line.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica.
• Improved the performance related to long running jobs.
• Collaborated closely with other developers, designers and key stakeholders during analysis, planning, design to delivery of the products (production release).

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

Confidential

Informatica Developer

Responsibilities:

• Participated in business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Designing and developing Informatica mappings to achieve the desired functionality.
• Creating reusable transformations and used in the mappings according to the 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 the issues within time line.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica.
• Improved the performance related to long running jobs.
• Collaborated closely with other developers, designers and key stakeholders during analysis, planning, design to delivery of the products (production release).

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