Senior ETL Developer
The primary focus is to develop a Datamart called as Symphony to support Headquarters Commercial Analytics and Field Sales Reporting Tool in [company name]. This DataMart integrates all its key departments such as R&D, Sales & Marketing, Peoplesoft, HR etc. The Datamart also stores its competitor market information which is eventually procure from IMS, Integrity systems.
- Created Integration Requirements and Design Specification Document.
- Provided architectural design for Informatica.
- Defined and designed flow and standards for Informatica.
- Worked closely with business analyst, multiple business units and a data solutions engineer to identify key information that enhance business decision-making.
- Documented ETL requirements translation of Business logic into ETL language.
- Involved in designing the Data Mart based on the requirement document using Informatica Power Center 9.0.1.