Onward Search

Philadelphia, PA

ETL Developer

Must have:
Minimum 5 years experience in ETL development
Hands on with XSLT, Unicode, XQuery, XML Schema
Experience in AWS environment
Talend, PostgresSQL and Apache Airflow are all a plus
Screening questions: Years of ETL exp? What tools are experienced with? Where did you work that was heavy in Agile?

Interview process – 3 steps; Review with VP and recruiter, MS Teams interview with VP and 2 leads, and Final interview with internal stakeholder

JOB DESCRIPTION:
At Clarivate, we believe human ingenuity can transform the world and improve our future. That’s why we harness our global reach, curate our content, and invest in best-in-class technology and people.

Join the team that is improving the way the world creates, protects, and advances innovation.

Data Architect responsible for the functional/technical track of project execution with medium to highly complex deliverable including requirements analysis & assignment, developer testing, code reviews and final release readiness and planning.

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+ year 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.


About Onward Search

Onward Select specializes in connecting top technology talent with jobs at the nation's most innovative companies. The company is a division of Onward Search, an international provider of recruitment and staffing services for digital, creative and marketing talent. Onward Select is headquartered in Red Bank, NJ with a growing base of satellite offices across the US. The company is a financially sound, privately held company, led by an executive team with over 20 years of experience in the technology staffing space. Onward Select offers a full range of recruiting, staffing, and talent management solutions to include temporary / contract staffing, temp-to-perm and perm placement / executive search to ensure its customers have access to the right talent to meet their needs in today’s rapidly changing marketplace.