— Design and Build ETL solutions utilizing Data Analysis, Dimensional Modeling and ETL Design
— Develop Informatica code, Design, Develop and modify Informatica mappings and workflows
— ETL performance tuning and optimization
— Maintain and Support DAC nightly schedule
— Leverage best practices, disciplined approaches, and standards to solving technical problems.
— Perform ongoing monitoring, optimization, and refinement of reports and BI solutions.
— Collaborate and work with cross functional IT teams.
— BA/BS degree in Computer Science or related field.
— 5+ years working in IT with a thorough understanding of SDLC methodology.
— 5+ years experience in Business Intelligence and Data Warehousing with strong experience working with the Informatica ETL tool (design and development)
— Able to design and architect an ETL solution, including Data analysis, Dimensional Modeling and ETL Design using Informatica in a Data warehousing environment
— Solid understanding of requirements for Data Quality, Metadata, Data Lineages, and Operational Data Management
— Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanism, standards and best practices.
— Previous experience with the Oracle Business Intelligence Applications Financial Analytics or Projects Analytics highly desirable.
— Previous experience integrating with SalesForce.com highly desirable.
— A strong sense of methodology, process and metrics.
— A self-starting team player able to operate in a fast-paced "Start Up"-like environment.
— Process and results-oriented.
— Our San Francisco client is hiring an Informatica ETL developer to support the data integration needs based on their OBIEE technology stack.
— This individual will work closely with the BI Architect in designing robust and scalable data integration solutions based on industry best practices. The candidate must have a strong background in Business Intelligence and Data Warehousing concepts.