SUMMARY

• With 9+ years of progressive experience in BI/DW technology as Business Intelligence Analyst & ETL Architect and Lead with Informatica PowerCenter (9.5, 9.1, 8.6, 8.1.1, 7.3), Informatica ETL in system analysis, develop & Administer ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager, Workflow Monitor & Admin console
• Deep knowledge in Business Process and Data Modeling, Architecture Design, Data Analytics, Data consistency, Data Migration testing and reporting.
• Deep domain knowledge in Financial Services (Insurance, Commercial Lending & Leases, Bank Security & regulation) related to Insurance, Risk and Finance.
• Expert in business process engineering and SDLC, AGILE methodology including analysis, design, development, testing and implementation of software applications.
• Remarkable experience in Informatica administration (Led upgrade projects from Informatica 6.x to 7.x, Informatica 7.x to 8.x & Informatica 8.x to 8.6 HA & Grid implementation)
• Expertise in Informatica (9.x) suite of products like PowerExhange, Informatica ETL tools and Teradata load scripts, ETL performance tuning, PL/SQL, Teradata SQL, Data Modeling, DB2 Mainframe, VSAM file handling.
• Strong experience in ETL workflows for multiple data sources like flat files, XML, Teradata, Mainframe DB2, Oracle, SQL Server.
• Management of global teams for business process support & service delivery (20+ team members) in a 24*7 support model
• Certification - Oracle Database: SQL Certified Expert
• Multiple career awards - Impact & Silver Award for successful Informatica Upgrade, Best Individual Performer & Best Team performer.

TECHNICAL SKILLS

ETL Tools: Informatica Power Centre 8x, 9.5

Reporting tools: Tableau (Desktop/Server, Public/Reader), Qlickview, Spotfire

RDBMS: Teradata, Oracle 9.x, 10g, Sql Server 2000/2005, Toad

Database skills: Stored Procedures, Database Triggers, Curser, Packages

Languages: SQL, PL/SQL, UNIX

OS: UNIX, Windows 2003/2007/XP

Tools: Remedy, Control-M, Visio-Flow, JIRA, HPQC, Autosys

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior ETL/PL SQL Developer

Responsibilities:

• Provide Technical expertise and implementation of data solutions.
• Analyze functional and non-functional requirements to create ETL Technical designs, data migration strategies to implement for data warehouse and datamart solutions.
• Interact with business users to translate business requirement to Technical requirements.
• High Level and low Level designing of the solution to provides team and users a framework for the effective transformation of data
• Developed Informatica mappings, design workflows and create batches and implement.
• Work on Informatica Power Center, Informatica PowerExhange for Metadata Analysis.
• Work on various sourcing platforms i.e. Oracle, SQL Server, DB2 mainframe to design & create SQLs.
• Extensive experience in Oracle, DB2 & Teradata to be able to write complex queries to evaluate data.
• Help debug existing ETL problem areas and provide effective solutions for problems including performance tuning of the batches
• Design and implement Primary Partitioning Indexes, Join Indexes, and other techniques for effecting database space management and archival.
• Develop test cases and coordinate system testing (beta and regression testing) with working group committee & Ensure Walkthroughs & Inspections are carried out as per standards.
• Provide support during business user acceptance testing and release of the product into the production environment and post production support

Environment: UNIX, Windows 7 Technology: Informatica 9.5, Informatica Power Exchange, SSIS, Mainframe DB2, IBM Data Studio 4.0, Oracle, MS SQL Server, Teradata SQL Assistant, MS ACCESS, MS Visio & MS Office

Confidential, New York

Senior Informatica Developer

Responsibilities:

• Requirements gathering and interacted with business process owners to translate the business requirements in Technical requirements
• Involved in high Level and low Level design of the solution utilizing UML diagramsto provides team and users a framework for the effective transformation of data
• Involved in Informatica mapping design, workflow design, creation and implementation.
• Worked on Informatica Power Center, Informatica PowerExhange. Experience in Informatica development with Informatica ETL on Oracle/Teradata/SQL Platforms.
• Used Teradata SQL and involved in Teradata physical data modeling.
• Design and developed ETL and ELT modules, and involved in ETL performance tuning.
• Developed and reviewed ETL workflows for multiple data sources like flat files, XML, Teradata, DB2, Oracle, SQL Server.
• Worked on Informatica Transformations like lookups, source qualifier, update strategy, router, sequence generator, aggregator, rank, filter jointer, sorter, mapplets, and web services, Java transformation.
• Involved in query tuning, performance triage/troubleshooting and data distribution
• Designed and implemented Primary Partitioning Indexes, Join Indexes, and other techniques for performance tuning.
• Developed test casesand coordinated system testing (beta and regression testing) with working group committee & Ensuring Walkthroughs & Inspection are carried out as per standards.
• Provide support during acceptance testing and release of the product into the production environment
• Analysis of change requests & Review of ETL Design / Build
• Developed training material

Environment: UNIX, Windows .X Informatica, Teradata, BTEQ, PL/SQL, Teradata Sql Assistant, Business Object, MS ACCESS & MS Office

Confidential

ETL Analyst/ Data Analyst

Responsibilities:

• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer.
• Reusing the single workflow for loading data from various regions’ files with similar file structure using indirect loading as source type in session properties.
• Facilitated by creating detailed level design for ETL(Extract Transform Load) with hands on PL/SQL, Unix and Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Worked with Transformations, Mappings, Mapplets, Workflows, Worklets and debugger to find bottleneck in mappings.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Creating and scheduling the PL/SQL Reconciliation Scripts of Oracle for checking validity of the data in the DWH.
• Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.
• Configured and scheduled Pre and Post Session commands with Shell Scripts and called them using command task.
• Used TOAD to run SQL queries and validate the data in warehouse.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Involved in the upgrade from Informatica Power center 8.6.1 to Informatica Power center 9.1.
• Wrote stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
• Performed unit test for Informatica mappings and workflows in both development and test environments.
• Used Incremental aggregation to capture new source data and in scenarios where the incremental changes do not significantly change the target so that the PowerCenter server updates the target incrementally.

Environment: Informatica PowerCenter 8.6.1/9.1, Oracle 10g, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5.