Business Intelligence (ETL Developer) - G6589

2 Weeks ago • 5 Years +

About the job

Summary_{By Outscal}

Nisum seeks a skilled Business Intelligence (ETL) Developer with 5+ years of experience in Oracle 8i/9i/10g, PL/SQL, SQL Loader, and DW/BI architecture. Expertise in data design, administration, and performance tuning is essential. Experience with web analytics tools like WebTrends, NetTracker, and Omniture is a plus.

Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto “Building Success Together®,” Nisum has grown to over 1,800 professionals across the United States, Chile,Colombia, India, Pakistan and Canada. A preferred advisor to leading Fortune 500 brands, Nisum enables clients to achieve direct business growth by building the advanced technology they need to reach end customers in today’s world, with immersive and seamless experiences across digital and physical channels.

What You'll Do

Business Intelligence developer in ETL/EDW areas, contributing to the development and able to identify avenues for automation.
Implement best practices and drive adoption around coding, design, quality, and performance.
Work collaboratively with other teams to foster an environment of respect, open communication, and cross-functional expertise.

What You Know

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.