Manager

Technology

Bangalore

About the job

The Technical Lead / Technical Consultant is a core role and focal point of the project team responsible for the whole technical solution and managing the day-to-day delivery. The role will focus on the technical solution architecture, detailed technical design, coaching of the development/implementation team, and governance of the technical delivery. Technical ownership of the solution from bid inception through implementation to client delivery, followed by after-sales support and best practice advice. Interactions with internal stakeholders and clients to explain technology solutions and a clear understanding of client’s business requirements through which to guide optimal design to meet their needs.

Must-Have Skills:

•    Database ( SQL server / SnowFlake / Teradata / Redshift / Vertica /  Oracle / Big query / Azure DW  etc)                
•    ETL tool (Talend, Informatica, IICS (Informatica cloud) )    
•    Experience in Cloud computing (one or more of AWS, Azure, GCP)        
•    Python, UNIX shell scripting, Project & resource management            
•    SVN, JIRA, Automation workflow (Apache Airflow, Tidal, Tivoli or similar)                


Good to have Skills: 
•    PySpark, Big Query, Familiar with NoSQL such as MongoDB, etc            
•    Client-facing skills

Key Responsibilities:

  • Ability to design simple to medium data solutions for clients by using cloud architecture using AWS/GCP
  • Strong understanding of DW, data mart, data modeling, data structures, databases, and data ingestion and transformation.​
  • Working knowledge of ETL as well as database skills
  • Working knowledge of data modeling, data structures, databases, and ETL processes​
  • Strong understanding 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
  • Translating technical requirements into ETL/ SQL application code
  • Document project architecture, explain the detailed design to the team, and create low-level to high-level design
  • Create technical documents for ETL and SQL developments using Visio, PowerPoint, and other MS Office package
  • Will need to engage with Project Managers, Business Analysts, and Application DBA to implement ETL Solutions
  • Perform mid to complex-level tasks independently
  • Support Clients, Data Scientists, and Analytical Consultants working on marketing solution
  • Work with cross-functional internal teams 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 include Code review, deployment, cod​
  • Work closely with the QA / Testing team to help identify/implement defect reduction initiatives
  • Work closely with the Architecture team to make sure Architecture standards and principles are followed during development
  • Performing Proof of Concepts on new platforms/validating proposed solutions
  • Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed
  • Must understand software development methodologies including waterfall and agile
  • Distribute and manage SQL development Work across the team

Qualifications:

  • Bachelor’s or Master's Degree in Computer Science with >= 7 years of IT experience
  • Database (Oracle / SQL server / Teradata / Vertica /  Redshift / Big query / Azure DW etc)
  • ETL tool (Talend, Informatica, Datastage), Python, UNIX shell scripting, Project & resource management, SVN, JIRA

Beware of Job Scams

We are aware of several scams targeting job seekers and candidates. Please be vigilant. All communication throughout the recruitment process will be from an official member of the dentsu recruitment team, using corporate email addresses (e.g., @dentsu.com or @merkle.com). We will never ask you to send money or vouchers to secure employment. If you suspect you have been a victim of a scam, please report the incident to your bank, local police, or fraud protection authority immediately. Additionally, you can report the scam to us at jobfraud@dentsu.com so we can take appropriate action to request the website is taken down. Please note that Merkle and dentsu are not responsible for any losses incurred as a result of these scams. We advise all individuals to exercise caution and verify the authenticity of any job offers or communications received.