Job Description :
Position Details

SR Number


APPS/APPS

BR Number




Client Name


Sonoco Products Company

Job Location/Client Location (with City & State)


South Carolina / Hartsville

Project Duration


3 Years

Project Start date


Already On-going




No of openings/positions


1

Job Title/Role


ETL Developer Lead

Mandatory Skills


ETL/ELT

Client Interview Needed for Selection (yes / No)


No

Detailed JD (Pl share the Detailed Description, 1 liner JD will not work)


7+ years’ experience in Data Warehouse modeling and architecture.
Experience designing, developing and maintaining Data Models and ETL processes.
Strong ETL/ELT background with experience working on real time jobs, batch jobs, job-scheduling and Web Services.
Strong SQL or PL/SQL query skills.
Experience working with multiple database technologies (SQL Server, Oracle, Postgres etc
Good data analysis experience using SQL - analyzing redundant and inconsistent data, diagramming data flows and process flows.
Good communication skills. Should be able to interact with business & IT teams.

Preferred:
SAP Business Objects technologies - Data Services and WEBI.
Experience working with cloud data warehouse technologies (SnowFlake, Actian Avalanche etc.
Knowledge/experience working on SAP HANA.
Familiarity with one or more job scheduling tools.

Good to have:
Knowledge of and/or being certified in Data Vault modeling will be a big plus.
Experience working with semi-structured datasets (XML, JSON etc will be good to have as well.
Exposure to different BI/Dashboarding tools - SAP Lumira,Qlik, PowerBI etc.
WhereScape or any other data warehouse creation automation tool experience.