Thegradcafe - Dallas, TX

posted about 1 month ago

Full-time - Mid Level
Dallas, TX
5,001-10,000 employees

About the position

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. The Senior Database Developer will collaborate with the tech team to understand business requirements, functional and technical specifications. They will analyze and define data flow requirements and prepare applicable system documentation and operation manuals as needed. The developer will utilize core solution standards to develop and implement initial data loads for database marketing projects, ensuring that data transformation and loading align with business specifications. Additionally, they will support production data loads and ongoing refreshes of the database systems. This position requires defining, preparing, executing, and implementing data validation and unit testing methods to ensure data quality. The Senior Database Developer will also be responsible for performing enhancements and bug fixes as required, maintaining reusable development standards that help implement each solution and/or enhancements to existing systems to meet current and future needs. The role includes maintenance of applications with Oracle 12C on Linux software, requiring strong experience in Oracle packages, procedures, functions, analytics functions, exchange partitions, and bulk load functionalities. Furthermore, proficiency in Unix KSH scripting is essential, as the developer will need to create custom wrappers to support the file load process.

Responsibilities

  • Works with Tech team to understand business requirements, functional and technical specifications.
  • Analyzes and defines data flow requirements and prepares applicable system documentation and operation manuals as needed.
  • Develops using core solution standards and implements initial data loads for database marketing projects.
  • Performs transformation and loading of data according to 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.
  • Maintains reusable 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.

Requirements

  • 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 and ability to create API calls.
  • 5+ years of experience in Data Warehouse development.
  • Strong experience in Oracle packages, procedures, functions, analytics functions, exchange partitions, and bulk load functionalities.
  • Strong Unix KSH scripting skills.

Nice-to-haves

  • Knowledge and experience with TFS or other source code control tools.
  • Experience with MS SQL, Oracle 12C, Linux, Windows batch scripting, and Powershell.
  • Experience in Database Performance Tuning.
  • Experience in Automation.

Benefits

  • Competitive pay
  • Comprehensive health coverage
  • Endless opportunities to advance your career
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service