ETL Developer

Philadelphia, Pennsylvania | Permanent | Job ID #59740 |
Posted
 

Analytics Firm based in Philadelphia is seeking an ETL Developer to join them on a perm full time basis.

Must Have:

  • Minimum 5 years experience in ETL development
  • Hands on with XSLT, Unicode, XQuery, XML Schema
  • Experience in AWS environment

Responsibilities:

  • Translating business requirements to technical specifications
  • Developing, deploying and maintaining technical specifications
  • Design, develop and maintain SSIS packages for ETL processes
  • Design, develop and maintain SQL schemas, triggers, functions and stored procedures
  • L3 Production support of ETL jobs
  • Develop and execute ad-hoc queries to support business analytics
  • Proactively communicates status reports and issues to management
  • Document ETL process thoroughly to allow peers for cross training enabling L2 support

Required Skills:

  • 4+ years experience in designing and data modeling Data Warehouse/ Data Lake
  • Experience in ETL/Backend/Database development
  • 7+ years experience in the following technologies: ORACLE, MSSQL, SSIS, ETL, PostgreSQL, MS-APS, Python for database development
  • Experience in design and development
  • Good understanding of MPP and NoSQL architecture
  • Good Data Modeling experience and concepts
  • Experience with ETL concepts and source control
  • Experience with Agile development methodologies Knowledge of technologies including OACS, Talend & ESSBASE
  • Strong ETL knowledge with Real Time jobs, batch jobs, scheduling and Web Services
  • Strong knowledge in Data Services and Data Quality transformations is must
  • Good data analysis experience using SQL, analyzing redundant and inconsistent data, diagramming data flows and process flows
  • Knowledge of agile/Kanban development delivery
  • Aptitude towards learning new technologies and solving complex problem
  • Proven skills to write technical specifications for data extraction and good quality code

Employer Details:

  • Onward Search is an equal opportunity employer, dedicated to a policy of non-discrimination in an employment with regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, veteran status or any other classification protected by federal, state and local laws and ordinances. Candidates must be at least 18 years old to be considered for employment. EOE/M/F/D/V/SO.
  • In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
  • Onward Search offers medical, dental, vision benefits, as well as a 401k program, for all eligible full time temporary assignments.
  • Onward Search is unable to support 1099 / Corp-to-Corp or Independent Contractor arrangements at this time. All freelancers will be paid as W2 employees.
  • Onward Search is a drug-free workplace.
Apply

SHARE THIS JOB

Turn on email alerts for this search

About Onward Search

Onward Search helps connect creative, marketing, and technology talent with top jobs at the nation's most recognized companies and digital agencies. We offer a full range of recruitment and staffing solutions to include freelance / contract, temp-to-perm, and permanent placement.