SUMMARY:

• An articulate Software Professional with 8+ years of experience in System Analysis, Integration Analysis Design, Coding, Testing, Maintenance & support of Data warehouse applications. Currently spearheading as ETL Architect and Tech Lead .
• Broad experience in full SDLC life cycle including requirement analysis, estimations, design, coding, testing and hyper care support for projects of Data warehousing using ETL tools such as Informatica PowerCenter, Informatica PowerExchange CDC
• Extensive experience in database technologies in Oracle, SQL Server, DB2 and knowledge on relational and dimensional modeling concepts. Has excellent and proven track record in delivering high visibility products successfully with efficient team management.
• Well versed in ETL tools/utilities like Informatica PowerCenter 9.5.1/ 9.0.1/8.6.1 /8.1, Informatica PowerExchange 9.0.1/8.6.1
• Extensively experienced with RDBMS skills in Oracle (6+ years), SQL Server (4+ years). Good experience with Unix Shell scripting (4+ years), DB2(1+ years).
• Excellent Batch scheduling(4+ Years) experience using tools like IBM Tivoli Job Scheduler, CA Autosys(JIL Script)
• Expertise in Data warehousing, Data migration and Data Integration projects as ETL Solution Architect, DW Lead and ETL Developer.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables.
• Worked on onshore - offshore team model as well as co-coordinating team from different geographical region.
• Functional requirement analysis and specification reviews with Business Groups and stake holders.
• Design Technical specifications of data mapping.
• Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Cobol Files, Oracle, SQL Server, MS Access, and Salesforce
• Proficient in designing and developing the various transformation logics by utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Extensively worked on Informatica Designer Components -- Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Performed below Informatica Admin activities
• Creating and maintaining Integration services and repository services from Admin console.
• Monitor service logs and recycle services in case of any issues.
• Setting up User, Groups and Manage connection, permissions using Admin console.
• Code Migration across application regions using Deployment group.
• Experience in Oracle PL/SQL programming (Writing Complex queries, Package, Store Procedure, Function, Trigger, View, Materialized views, Index), and SQL Server scripting.
• Proficient in writing Unix shell scripting using Korn shell, AWK, SED and schedule jobs using crontab.
• Hands on experience in tuning the performance of SQL queries and ETL process.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.0.1/8.6.1 /8.1/7.0, Informatica PowerExchange 9.0.1/8.6.1

RDBMS: ORACLE 10g (PL SQL), SQL-Server 2000, DB2

SQL Tools: SQL Navigator, Toad, SQL Developer, SQL Enterprise Manager

Scripting: Unix Shell scripting

Batch Scheduling Tool: IBM Tivoli Job Scheduler, CA Autosys(JIL Scripts), CronTab Scheduler

Hardware/OS: Pentium, Sun-Solaris, Windows XP/2000/NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, FairField, Connecticut

ETL Architect

Technology: Informatica Powercenter 9.5, Oracle 11g,Unix Shell Scripting, Oracle SQL Developer

Responsibilities:

• Led requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Engage Data Architecture team for Data Modeling and DBA for database object creations if required.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.

Confidential, Simsbury, Connecticut

ETL Onsite Lead

Technology:Informatica Powercenter 9.5/8.6, Oracle 11g,Unix Shell Scripting, Oracle SQL Developer, Autosys

Responsibilities:

• Led requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Engage Data Architecture team for Data Modeling and DBA for database object creations if required.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.

Confidential, Bridgewater, New Jersey

ETL Onsite Lead

Technology:Informatica Powercenter 8.6, Oracle 10g PL/SQL 10g/9i, Unix Shell Scripting, Toad, Sales Force Cloud.

Responsibilities:

• Functional analysis, requirement management and co-ordination with technical teams and business partners.
• Data analysis and modeling, discussions with Data Architect.
• Team co-ordination for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Schedule the batch jobs using Unix corn tab Scheduler.

Confidential, Bridgewater, New Jersey

ETL Onsite Lead

Technology:Oracle PL/SQL 9i/8i, Informatica Power center 8.6, UNIX Shell Scripting, Toad, SQL Developer 2000, Autosys Scheduler

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Design and develop batches in Unix shell scripts that would use the Oracle package and generate files in the application file systems.
• Design and develop Autosys scripts to schedule overnight batch streams that would use the Unix KSH.

Confidential, Bridgewater, New Jersey

ETL Onsite Lead

Technology:Oracle PL/SQL 9i/8i, Informatica Power center 8.6, UNIX Shell Scripting, Toad, SQL Developer 2000, Autosys Scheduler

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Design and develop batches in Unix shell scripts that would use the Oracle package and generate files in the application file systems.
• Design and develop Unix CronTab scripts to schedule overnight batch streams that would call the Unix KSH.

Confidential, Detroit, Michigan

ETL Developer/Onsite Coordinator

Technology:Informatica 8.1, Oracle 9i/10g/11g (PL/SQL), Unix Shell Scripting.

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Design and develop batches in Unix shell scripts that would use the Oracle package and generate files in the application file systems.

Confidential

Developer

Technology: Informatica 7, Oracle 9i/10g (PL/SQL),DB2 SQL, Unix Shell Scripting

Responsibilities:

• Enhance/Modify/Implement new changes as requested by Business team throughout the project life cycle.
• Preparing estimates for the change requests.
• Provide centralized governance, technical artifacts, platforms and best practices.
• Consult the business and technical team on all technical and functional issues and help design effective solutions.
• Design, development and unit testing of enhancements
• Coordinating and migrating the change requests to production environment.
• Providing solutions to tickets raised in Help desk of Confidential for ETL Processes.
• Involved in the designing the Metrics reports for the project.
• Responsible for the quality related aspects of the project confirming to the quality guidelines of the organization.
• Involved in completing change requests raised in Remedy.

Confidential

Developer

Technology:Informatica 7.1, Oracle 9i/10g (PL/SQL),DB2 SQL, Unix Shell Scripting

Responsibilities:

• Enhance/Modify/Implement new changes as requested by Business team throughout the project life cycle.
• Preparing estimates for the change requests.
• Provide centralized governance, technical artifacts, platforms and best practices.
• Consult the business and technical team on all technical and functional issues and help design effective solutions.
• Design, development and unit testing of enhancements.
• Coordinating and migrating the change requests to production environment.
• Providing timely solutions to the tickets raised in ING Help desk/ Remedy for ETL Processes.
• Involved in the designing the Metrics reports for the project.
• Responsible for the quality related aspects of the project confirming to the quality guidelines of the organization.

Confidential

Developer

Technology:Informatica 7, Oracle 9i/10g (PL/SQL),DB2 SQL, Unix Shell Scripting

Responsibilities:

• Create Registraction Maps, Extract Definition and Data Maps using Informatica PowerExchange to capure Change data.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Provide timely project progress status to Onsite coordinator

Confidential

Developer

Technology: Informatica 7, Oracle (PL/SQL),DB2 SQL, Unix Shell Scripting

Responsibilities:

• Create Registraction Maps, Extract Definition and Data Maps using Informatica PowerExchange to capure Change data.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Provide timely project progress status to Onsite coordinator

Confidential

Developer

Technology: Informatica 6.1, Oracle 9i (PL/SQL),DB2 SQL, Unix Shell Scripting

Responsibilities:

• Create Registraction Maps, Extract Definition and Data Maps using Informatica PowerExchange to capure Change data.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Provide timely project progress status to Onsite coordinator.