Technical Architect - Sql Implementation

Company Description

About Merkle

Merkle, a dentsu company, is a leading data-driven customer experience management (CXM) company that specializes in the delivery of unique, personalized customer experiences across platforms and devices. For more than 30 years, Fortune 1000 companies and leading nonprofit organizations have partnered with Merkle to maximize the value of their customer portfolios. The company’s heritage in data, technology, and analytics forms the foundation for its unmatched skills in understanding consumer insights that drive hyper-personalized marketing strategies. Its combined strengths in consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions drive improved marketing results and competitive advantage. With more than 14,000 employees, Merkle is headquartered in Columbia, Maryland, with 50+ additional offices throughout the Americas, EMEA, and APAC. For more information, contact Merkle at
1-877-9-Merkle or visit www.merkle.com.

Job Description

Key Responsibilities:

Roles & Responsibilities                                                                                                           

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

Qualifications

      Mandatory skills (top 5)                                         

• Database ( SQL server / SnowFlake / Teradata / Redshift /Vertica /  Oracle / Big query / Azure DW  etc)                                  
• ETL tool (Talend, Informatica, SSIS, Datastage)                                  
• Python, UNIX shell scripting, Project & resource management      
• SVN, JIRA, Tidal (Automation workflow)       

      Preferred (top 5)                                       

• Experience in Cloud computing (one or more of AWS, Azure, GCP)          
• Tivoli                                              
• Matillion (ETL)                                            
• MS Office                                      
• Client-facing skills                     

Additional Information

Work timing : 

• 2:00 PM to 11:00 PM (However it will change to 4:30 PM to 1:30 AM during the discovery phase)