ETL Developer
Onward Search

Job Info

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


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.
The client 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.

New post from our employment blog

3 Thoughts on How to Dress (and get ready) for a Job Interview

3 Thoughts on How to Dress (and get ready) for a Job Interview

Ok, you have made it to an interview! Now that you have made it, a question you should ask yourself is “What should I wear?”. 

Read full blog post
Share this job with the community

Click a community link below, and then social share the ETL Developer job.

African American Job Search Logo
Asian Job Search Logo
Disabled Job Seekers Logo
Hispanic Job Exchange Logo
LGBT Job Search Logo
Seniors to Work Logo
US Diversity Job Search Logo
Veteran Job Center Logo