We provide IT Staff Augmentation Services!

Sr Etl Informatica/ Lead / Architect Resume

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

Hire Now