Senior Database Developer - Irving, United States - Epsilon

    Default job background
    Description
    Job Description

    Epsilon is seeking a Senior Database Developer to implement, maintain and support proprietary database systems.


    This role is responsible for the development, implementation and testing of data extraction, transformation and load programs for large database projects.

    As part of the technical delivery team, the Senior Database Developer will work

    with the internal project delivery team to design solutions and implement programs according to the requirements

    and timelines specified in each statement of work.

    Responsibilities

    Works with Tech team, understand the business requirements, functional and technical specifications.

    Analyzes and defines data flow requirements and prepares applicable system documentation and operation manuals as needed.

    Develop using core solution standards and implements initial data loads for database marketing projects.

    Performs transformation and loading of data according to the business specifications.

    Supports production data loads and ongoing refreshes of the database systems.

    Defines, prepares, executes and implements data validation and unit testing methods to ensure data quality.

    Performs enhancements and bug fixes as required.

    Maintain re-useable development standards that help implement

    each solution and/or enhancements to existing systems to meet current and future needs.

    Responsible for maintenance of applications with Oracle 12C with Linux software

    Must have strong experience in Oracle packages, procedures, functions, analytics functions, exchange partitions, bulk load functionalities

    Must have strong unix KSH scripting, been able to come up with functions, create custom wrappers to support the file load process

    Qualifications

    Bachelor's Degree required.

    5+ years of overall database development experience is required.

    5+ years of experience in Unix scripting

    5+ years of experience in windows batch scripts/been able to create API calls.

    5+ years of experience in Data Warehouse development.

    Knowledge and experience with the following is a plus:

    TFS, or other source code control tools.

    MS SQL, Oracle 12C, Linux, Windows batch scripting.

    Powershell

    Database Performance Tuning

    Automation


    Non-Technical:
    Experience in marketing

    Excellent Analytical and problem solving skills

    Ability to diagnose and troubleshoot problems quickly

    Motivated to learn new applications and domains

    Strong time management skills

    Ability to take full ownership of tasks and projects

    Behavioral Attributes:
    Team player with good interpersonal skills

    Good verbal and written communication skills

    Possesses Can-Do attitude to overcome challenges

    Self-motivated and directed


    The ideal candidate will be deadline focused, detail oriented, well organized and self-motivated with the ability to juggle multiple projects simultaneously and manage time efficiently.

    #J-18808-Ljbffr