SUMMARY:

• Seasoned IT professional with comprehensive business/technical skill set and expertise in business intelligence, enterprise data warehouse (EDW), requirements analysis, design, build, testing and leadership.
• Highly qualified senior level consultant offering over 10 years of commercial experience working for companies within several industries including Banking, Insurance, Retail, Marketing, and Housing & Financial Services.
• Expert experience in implementing end - to-end BI solutions using Informatica (Development & Administration) and Informatica IDQ as Solution Architect
• Very Good Experience in Data Modeling and Architecting Data.
• Very Good Experience in Data Profiling using Informatica IDQ and Informatica Analyst.
• Worked on numerous enterprises level Informatica solutions for IBM, Ness Technologies, Tech Mahindra and WIPRO.
• Experience across all phases of SDLC from project initiation to post implementation
• Experience in ETL/ELT processes. Worked extensively on data extraction, cleansing /data integration and loading from different data sources using Informatica and Teradata
• Experienced in developing DWH processes based on Informatica Power Center, SQL/PLSQL, MS-SQL Server and DBA skills.
• Excellent experience on data migration and SQL.
• Knowledge of various data modelling techniques: star schema, snowflake(Kimball Methodology), FSLDM
• Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP
• Excellent Reconciliations, Debugging and performance tuning skills across ETL and reporting levels. Good experience on version control, scheduling ( Autosys, Redwood Chronicle).
• Worked in Waterfall and Agile project Methodologies.
• Exceptional problem solving and mentoring skills.

TECHNICAL SKILLS:

ETL tools:: Informatica 6X/7X/8X/9x (Development & Administration). IDQ.

Industries:: Telecom, Insurance, Banking

Operating Systems:: Windows Family, UNIX

Languages:: SQL

Databases:: Oracle8i/9i/10g/11i

Defect Management:: HP Quality Center

BI/DW Skills Highlights

PROFESSIONAL EXPERIENCE:

Confidential

SR ETL INFORMATICA/ LEAD / ARCHITECT

Responsibilities:

• Played a lead role as Informatica Administrator and solution designer
• Working with various technologies like Real time messages, xml’ Confidential
• Coordinating with Onsite Team and client, for Requirements gathering and analysis.
• Developed ETL framework for Informatica objects as per standards
• Creating and Reviewing of Macro Design and Micro Design Documents based on the DLG solution outline document.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.
• Checking the implementation feasibility of Technical Designs.
• All Informatica Admin related tasks,

Environment: Informatica 9.1.6, SQL Developer, UNIX, Teradata

Confidential

SR ETL INFORMATICA/ LEAD / ARCHITECT

Responsibilities:

• Playing a lead role and as Informatica Administrator
• Coordinated with Onsite Team and client, for Requirements gathering and analysis.
• Creating and Reviewing of Macro Design and Micro Design Documets
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.
• Checking the implementation feasibility of Technical Designs.
• All Informatica Admin related tasks, Have Done the Informatica Migration from Version 8 to 9

Environment: Informatica 8.6.1 HotFix10, Oracle, UNIX, WinSCP, SQL Developer, Altova XML Spy, Putty

Confidential

Informatica Developer and Administrator

Responsibilities:

• Played a lead role and as Informatica Administrator at client site for ETL Team
• Coordinated with Onsite Team and client, for Requirements gathering and analysis.
• Involved in understanding and reviewing the Confidential ETL framework for developing the Informatica objects as per standards
• Creating and Reviewing of Macro Design and Micro Design Documents based on the Confidential GFT solution outline document.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.
• Checking the implementation feasibility of Technical Designs.
• All Informatica Admin related tasks, have Done the Informatica Migration from Version.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Oracle

Confidential

Informatica Developer

Responsibilities:

• Understanding and reviewing the Confidential ETL framework for developing the Informatica objects as per standards
• Creating and Reviewing of Macro Design and Micro Design Documents based on the Confidential solution outline document.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Teradata

Confidential

Informatica Developer Achmea SolvencyII

Responsibilities:

• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Coordinating with Onsite Team and client, for Requirements gathering and analysis.
• Participated in peer review of Informatica objects.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Teradata

Confidential

Informatica Developer

Responsibilities:

• Designed and developed complex mappings from varied transformation logic like source qualifier, unconnected and connected lookups, router, filter, expression, aggregator, joiner, update strategy and more.
• Designed the mappings for slowly changing dimensions (SCD1, SCD2)
• Participated in peer review of Informatica objects.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Oracle

Confidential

Informatica Developer

Responsibilities:

• Designed and developed complex mappings from varied transformation logic like source qualifier, unconnected and connected lookups, router, filter, expression, aggregator, joiner, update strategy and more.
• Designed the mappings for slowly changing dimensions (SCD1, SCD2)
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Oracle

Confidential

Informatica Developer

Responsibilities:

• Worked as a Onsite coordinator in Switzerland
• Understanding the business rules completely based on High Level document specifications and implementation of the data transformation methodologies.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 9.1.6, SQL Developer, UNIX, Oracle

Confidential

Informatica Developer

Responsibilities:

• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 7, SQL Developer, UNIX, Oracle

Confidential

Informatica Developer

Responsibilities:

• Worked as a Onsite coordinator in UK
• Understanding the business rules completely based on High Level document specifications and implementation of the data transformation methodologies.
• Participated in peer review of Informatica objects.
• Coding the Informatica Objects & Reusable Objects as per Client’ Confidential BI standards.
• Involved in Unit Testing, Integration Testing and System Testing.
• Created Shell Scripts in AIX-UNIX.

Environment: Informatica 6, SQL Developer, UNIX, Oracle