ETL/BI ANALYST & TECHNICAL LEAD

06-21-2012

ETL/BI ANALYST & TECHNICAL LEAD

6+ Years of ETL design, OBIEE/Essbase exp & strong in Oracle SQL, PL/SQL data analysis Must have strong exposure to Data, ETL Informatica systems analysis Experience in Requirements gathering & Analysis Must have strong Oracle SQL, PL/SQL query based data analysis ability Experience/Exposure to Essbase will be added advantage Exp in Sales & Marketing and Manufacturing Data warehouse will be advantage Expertise in performance engineering in ETL applications User interface experience with Good verbal and written communications skills are needed. Responsible for translating business needs into technical solutions and specifications, and designing relational and dimensional models to meet project requirements. Develop, manage, and update conceptual, logical, and physical data models in a multi-tiered Data Warehouse environment. Possess proven skills in both dimensional and relational data modeling and have a clear understanding of how ETL (Extraction, Transformation and Loading) and BI (Business Intelligence) tools influence the final database design. Responsible for understanding source system database structures and underlying data. Perform data profiling, analysis, and knowledge transfer expertise to project team members. Design, develop, maintain, test, reverse engineer, and modify ETL (Extraction, Transformation and Loading) processes within the context of Business Intelligence and Data Warehousing solutions. Possess proven skills and sound knowledge of ETL/BI processes and best practices and be experienced in development activities. Collaborate with team members throughout the SDLC to perform model reviews, data reviews, issues resolution, and assure the successful delivery of the Panel Reprogramming solution. Candidates should have no less than 5 years of experience with Data Analysis, Database Design (ERWin or Embarcadero on Oracle platform), and ETL Development using Informatica Power Center. Strong ETL, Oracle, Essbase system data analysis and DW user requirement gathering & analysis Good team member and willing to share workload as needed Bachelor of Engineering/Computer Applications, IT & Science in Masters degree preferred. Columbus, Indiana.

Apply