Job Details:

Job Title : ETL Developer/Database Engineer

Location : Philadelphia, PA

Type : Direct Hire Position

Client : Pepperjam

Overview:

Our technology team is seeking an experienced Database Engineer and ETL Developer to join our cross-functional software development team. They will lead the Database and ETL design, deployment, maintenance and optimization of highly scalable, reliable and fault tolerant Data Warehouse and ETL in cloud-based environments. You will work alongside experienced and motivated professionals and will have a big impact on shaping cutting edge online marketing technology within a fast moving and highly effective agile team.

Responsibilities

· Design logical and physical data models for the Data Warehouse Database using Dimensional Modeling

· Design, develop and maintain ETL/ELT processes and solutions

· Provide technical expertise to design efficient solutions integrating data from MySQL database, Redshift, feeds and other sources through ETL processes

· Able to work with the reporting team to design and develop robust data models that simplify the reporting solution

· Develop, maintain and document data model, data dictionary and data flow diagrams

· Document database development guidelines, standards, and performance reviews

Qualifications

· 3+ years of experience developing in any ETL tool like Informatica, Data Stage, Talend or Matillion for Redshift

· Experience with querying, data modeling and optimization of MPP databases like Netezza, Teradata, or Redshift

· Strong experience with Dimensional and relational Database design

· Familiarity with reporting tools and how they consume data from the Data Warehouse Databases

· Working knowledge and the ability to take on simple reporting tasks is a strong plus

· Ability to work collaboratively with team members from the Engineering team and the Business stakeholders

· Familiarity with Agile software development methodologies

· Ability to keep up with emerging technologies

Mail to: Bob@directit-staffing.com