The 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.
The Solution Developer must work with the assigned IT Architect and IT Solution Lead to understand the design of the database solution. The 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.
Reports to: Supervises:
IT Manager or IT Director, Solutions Delivery None
PRIMARY DUTIES AND RESPONSIBILITIES
Works with IT Solution Lead or IT Architect to understand solution design and component instructions, may 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.
Follow industry and Allant standards and best practices.
Interacts directly with client stakeholders who are in business and/or technical roles.
Proficient in use of Oracle SQL.
Proficient ETL developer.
Proficient working on UNIX/Linux platforms.
Proficient interpreted language developer.
Proficiency with Oracle DDL used to create tables, indexes, and foreign keys.
Familiarity working with large data volumes (millions to billions of records).
Familiarity with performance tuning SQL, including use of explains plans, partitions, Oracle hints etc.
Proficient in data warehousing concepts and constructs, including star schema data models.
Proficient in creating detailed technical specifications from customer requirements and IT Architect designs.
Comfortable 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.
Proficient in participating in design and code reviews.
Proficient in identifying and communicating scope changes.
Proficient in educating and mentoring production staff on technical issues.
Proficient in creating reasonable and accurate time estimates for assigned tasks.
Capable of 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.
Must be US Citizen or permanent resident.
Limited travel may be required.
Proficient in the creation and modification of Perl scripts.
Proficient in PL/SQL.
Proficient in the creation and modification of web services.
Experience 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).
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.
MENTAL AND PHYSICAL REQUIREMENTS
Ability to maintain high level of visual attention and mental concentration for significant periods of time.
Ability to manipulate necessary office equipment, computers, and peripherals.
Prolonged periods of sitting and exposure to computer screens.
General mobility to move within office environment.
Ability to lift and carry up to 30 pounds.
Ability to work with others in a mature, respectable and responsible manner.
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.
2+ years’ experience as an Oracle developer.
2+ years of experience setting up and developing ETL applications and processes.
3+ years’ experience developing on UNIX/Linux platforms.
2+ years developing with interpreted languages (e.g. shell scripts, PL/SQL, Perl, or similar).
2+ years’ experience working in a data warehouse or data mart environment.
Capacity to continue to learn new skills and technologies as defined by Allant Management.