Manager
DGS India - Bengaluru - Manyata H2 block
dentsu
At dentsu, innovation is our strength, and your growth is our mission. We help you keep up with technological changes in the digital economy.Job Description:
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
Location:
BangaloreBrand:
MerkleTime Type:
Full timeContract Type:
Permanent* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Airflow Architecture AWS Azure BigQuery Computer Science ETL GCP Informatica Jira MongoDB NoSQL Oracle PySpark Python RDBMS Redshift Shell scripting Snowflake SQL Talend Teradata Testing
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.