Tech Lead (DB & ETL)

Company Description

Merkle, a dentsu company, is a leading data-driven customer experience management enterprise specializing in delivering unique, personalized customer experiences across platforms and devices. With over 30 years of experience, Merkle partners with Fortune 1000 companies and non-profit organizations to optimize their customer portfolios. Its expertise in data, technology, and analytics enables it to gain insights into consumer behavior, driving hyper-personalized marketing strategies. Merkle's consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions capabilities combine to drive improved marketing results and a competitive edge. With over 14,000 employees, Merkle is headquartered in Columbia, Maryland, with more than 50 additional offices worldwide. Its innovative solutions enable brands to build meaningful customer relationships and enhanced customer experience.

Job Description

Total Experience : 8 - 10 Years

Must Have Skills : 

1. Database (Oracle / SQL server / Teradata / Vertica /  Redshift / Big query / Azure DW etc)
2. ETL tool (Talend, Informatica, Datastage)
3. Python, UNIX shell scripting, Project & resource management
4. SVN and JIRA

Good to Have Skills : 

1. Experience in Cloud computing (one or more of AWS, Azure, GCP)
2. Tidal (automation tool)
3. Matillion (ETL)
4. MS Office
5. Client-facing skills

Roles & Responsibilities :

1. Ability to design simple to medium data solutions for clients by using cloud architecture using AWS/GCP
2. Understanding of DW, data mart, data modelling, data structures, databases, and data ingestion and transformation.​
3. Understand ETL as well as database skills
4. Understand of data modelling, data structures, databases, and ETL processes​
5. Understand of relational and non-relational databases and when to use them​
6. Leadership and communication skills to collaborate with local leadership as well as our global teams
7. Document project architecture, explain detailed design to team and create low level to high level design
8. Perform mid to complex level tasks independently
9. Support Client, Data Scientists and Analytical Consultants working on marketing solution
10. Work with cross functional internal team and external clients​
11. Strong project Management and organization skills​. Ability to lead 1 – 2 projects of team size 2 – 3 team members.​
12. Code management systems which inlcudes Code review, deployment, cod​

Qualifications

1. Bachelor's degree or work experience that demonstrates comparable abilities