Business Intelligence (ETL Developer)
- A minimum of 5+ years of proven professional experience is required.
- Experience with Oracle 8i, 9i and 10g including PL/SQL, SQL loader, external tables, partitioning and performance tuning.
- Strong knowledge of Oracle data structures, data dictionary, and RDBMS structures. Experience as data architect and/or DW/BI architecture.
- Experience in database design and administration, strong in performance tuning, software installation, scripting, PL/SQL coding, backup & recovery process.
- At least 2 medium to large scale DW/BI project implementation experience. Experience working with DW/BI environment to be able understand the concepts of STAR, data cleansing, transformation and aggregations.
- 4+ years, current, development experience and inclination towards development.
- 1+ years experience with web analytics products like web trends, NetTracker, Omniture etc..
- Experience working in an environment that has come across customer integration issues or has addressed it using MDM.
- Ability to express business and technical concepts clearly and concisely both verbally and in writing.
- Aggressive approach to staying current with developments within the internet world, related web analytics & data management.
- Experience working in a team-oriented, collaborative environment.
- Good to Have Skills:
- Experience working with various business applications like campaign management, CRM, ERP. Experience with Java scripts or any other web front end scripting.
- Experience with column oriented database solutions such as HBase or Infobright.
- Experience with Hadoop. Oracle database administration experience.
- Experience working with various data reporting tools like Business Objects, MicroStrategy, COGNOS.
- Experience working with ETL tools like Data Stage, Informatica, Hummingbird.
- Experience working with meta data management.
- Experience with SAS.