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