Job Description :
Position Details

SR Number


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


Job Title/Role

ETL Developer Lead

Mandatory Skills


Client Interview Needed for Selection (yes / 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.

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.