ETL Developer; Acurian (A PPD Company)

Information Technology
959 Total Views
Apply for Job
Recommend to a Friend
Sign Up for Job Alerts

Summarized Purpose: 

Provides systems analysis, design, development, testing and support for moderately complex technical information system components.

Essential Functions 

  • Designs and develops components and services according to specifications within a team environment.
  • Prepares detailed system documentation including requirements, specifications, test plans and user manuals.
  • Performs unit and system tests and, as needed, validation testing.
  • Assists DBA with database design.
  • Coordinates with Operations staff on deployment of applications.
  • Works with business partners to analyze and address support requests including training.
  • Provides support for existing systems and technologies, including second line application support during and after deployment.
  • Ensures all activities are performed with quality and compliance.
  • Design and implementation of ETL batches that meet the SLAs for the business’ Business Intelligence reporting.
  • Development of data collection, data staging, data movement, data quality and archiving strategies.
  • Plan and conduct ETL Unit and development tests, monitoring results and taking corrective action when necessary.
  • Design automation processes to control data access, transformation and movement and ensures source system data availability


Education and Experience: 

Bachelor's degree or equivalent and relevant formal academic / vocational qualification


Previous experience that provides the knowledge, skills, and abilities to perform the job (comparable to 3+ years’).

Knowledge, Skills and Abilities:

  • Experienced in the use of the Talend ETL tool.
  • Client focused approach with strong interpersonal skills
  • Must be able to multitask and pay close attention to detail
  • Solid knowledge of basic relational database platforms  (Oracle, SQL Server) and languages (PL/SQL, SQL)
  • Strong logic, analysis, and problem solving skills
  • A good understanding of the concepts and best practices of data warehouse ETL design.
  • Have designed and developed ETL work packages on at least one data warehouse project.
  • Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively

Management Role:

No management responsibility 


Working Conditions and Environment:

  • Work is performed in an office environment with exposure to electrical office equipment.
  • Occasional drives to site locations with occasional travel both domestic and international.

Physical Requirements:

  • Frequently stationary for 6-8 hours per day. 
  • Repetitive hand movement of both hands with the ability to make fast, simple, repeated movements of the fingers, hands, and wrists.  
  • Frequent mobility required.
  • Occasional crouching, stooping, bending and twisting of upper body and neck.    
  • Light to moderate lifting and carrying (or otherwise moves) objects including luggage and laptop computer with a maximum lift of 15-20 lbs.
  • Ability to access and use a variety of computer software developed both in-house and off-the-shelf.
  • Ability to communicate information and ideas so others will understand; with the ability to listen to and understand information and ideas presented through spoken words and sentences.
  • Frequently interacts with others to obtain or relate information to diverse groups.  
  • Works independently with little guidance or reliance on oral or written instructions and plans work schedules to meet goals.  Requires multiple periods of intense concentration.
  • Performs a wide range of variable tasks as dictated by variable demands and changing conditions with little predictability as to the occurrence.  Ability to perform under stress.  Ability to multi-task.  
  • Regular and consistent attendance.

Previous Job Searches

Similar Listings

Horsham, Pennsylvania, United States

📁 Information Technology

Horsham, Pennsylvania, United States

📁 Information Technology

Horsham, Pennsylvania, United States

📁 Information Technology