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.