We are seeking a Senior Solutions Developer with strong background in Oracle SQL and data warehousing/ETL.
The Senior Solution Developer is responsible for developing applications and processes that are required to extract, transform, cleanse, and manage data and metadata to be loaded into a data warehouse, data mart, or operational data store that serves Allant’s marketing clients.
- Ability to design, code, test and deploy large Data Warehouse enhancements
- Ability to lead other developers - assigning and managing workloads to meet project timelines
- Strong Oracle SQL skills, including experience performance tuning SQL and working with large data volumes (billions of records)
- Experience working with Kimball dimensional modeling
The Senior Solution Developer must work with the assigned IT Architect and IT Solution Lead to understand the design of the database solution. The Senior Solution Developer is responsible for developing the processes required to construct the database solution according to the design and specifications provided by the IT Architect and IT Solution Lead.
Works with IT Solution Lead or IT Architect to understand solution design and component instructions, will aide in the creation of design documentation.
Develops extraction, transformation, and load (ETL) processes.
Develops queries to manage data within the database.
Completes data mapping and transformation programs.
Defines and captures metadata and rules associated with ETL processes.
Creates and executes unit tests and documents results.
Supports QA Analyst during functional, integration or system testing, and UAT.
Supports implementation of solution into production.
Creates and maintains design and production system documentation.
Follows industry and Allant standards and best practices.
Interacts directly with client stakeholders who are in business and/or technical roles.
Technical Requirements –
Expert in use of Oracle SQL.
Expert ETL developer.
Expert working on UNIX/Linux platforms.
Proficient in the creation and modification of Perl scripts.
Proficient in working with Oracle Analytic functions.
Database marketing development or production experience.
Experience with Business Intelligence Tools (e.g. Business Objects, Cognos, Qlikview, Microstrategy).
Experience with Campaign Management Tools (e.g. Unica, Alterian, Neolane).
Expert with Oracle DDL used to create tables, indexes, and foreign keys.
Proficient working with large data volumes (millions to billions of records).
Proficient with performance tuning SQL, including use of explains plans, partitions, Oracle hints etc.
Expert in data warehousing concepts and constructs, including star schema data models.
Expert in creating detailed technical specifications from customer requirements and IT Architect designs.
Expert in working in a hands-on development environment using custom scripts and in-house technologies, without the aid of third party ETL Tools such as Informatica, IBM Data Stage, Ab Initio and Oracle Warehouse Builder.
Non-Technical Requirements -
Able to work independently and within small IT teams (5-10 IT professionals).
Self-motivated and self-managing.
May be asked to supervise or mentor other Solution Developers.
Expert in participating in design and code reviews.
Expert in identifying and communicating scope changes.
Expert in educating and mentoring production staff on technical issues.
Expert in creating reasonable and accurate time estimates for assigned tasks.
Proficient in interviewing and assessing new Solution Developer candidates.
Strong interpersonal and verbal communications skills; proven experience with direct client interaction is preferred.
Strong documentation skills; must have experience writing technical design documents, including technical process flow diagrams.
Limited travel may be required.
Proficient in PL/SQL.
Proficient in the creation and modification of web services.
STANDARDS OF PERFORMANCE
Proven ability to write and support Allant’s programs/systems.
Demonstrated understanding and use of Unix operating system.
Ability to work productively with minimal supervision.
Strong analysis and problem resolution skills.
Authoring system documentation and user training/turnover .
Proactive and informed participation in team meetings and user discussions.
Cooperation and support of clients and Management.
Management of multiple concurrent projects and making full use of work time.
Good track record showing that work is on time and correct.
Demonstrated actions that indicate mentoring, training, and assistance.
Minimal if any travel required.
EDUCATION, TRAINING, AND EXPERIENCE
B.S. degree or equivalent work experience in computer programming, analysis, and design is required. Education should include both formal and work related experiences.
5+ years’ experience as an Oracle developer.
5+ years of experience setting up and developing ETL applications and processes.
6+ years’ experience developing on UNIX/Linux platforms.
5+ years developing with interpreted languages (e.g. shell scripts, PL/SQL, Perl, or similar).
5+ years’ experience working in a data warehouse or data mart environment.
Eagerness to continue to learn new skills and technologies as defined by Allant Management.
Allant is an E-Verified Employer.