Data Delivery Architect - Thane, India - Ugam

Ugam

Verified Company

Thane, India

2 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Company Description

This opportunity is within dentsu's integrated global capability that delivers world-class, agile services across the dentsu network - Dentsu Creative, Dentsu Media and Merkle.

In this role, you will be part of Merkle, enabling delivery of innovative data and technology solutions for Merkle's global brands.

Job Description:

Development Delivery Architects create the overall data integration architecture and design of multi-terabyte marketing solutions that integrate and optimize our client's data across numerous sources.

Merkle's solutions enable our clients to better communicate to their customer and prospects across a number of marketing channels and media.

Delivery Architects will be immersed in the development and maintenance of marketing database solutions to meet client business objectives. You will have an opportunity to work with a cross-disciplinary team across various divisions of the MS group.

Total Experience: 10 to 14 Years

Experience:

68+ years experience with ETL tool(s) Talend, Informatica, SSIS, DataStage
68+ years experience with Microsoft SQL Server, Oracle or other major RDBMS
10+ years experience leading CRM solution implementations
5+ years leading multifunctional development teams
Experience with Customer Data Integration or Master Data Management preferred
Experience in database marketing preferred
Experience with cloud technologies AWS, GCP, Azure and/or Hadoop is a preferred
Significant experience designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts
Technical consulting experience a plus
Wellversed in the CRM technology and tools landscape
Strong willed, creative thinker with history of strong problem solving
Articulate, effective communication skills with both technical and business audiences

Skills:

Exceptional understanding of ETL concepts, processes, and tools
Talend, Informatica, SSIS, or DataStage
Exceptional understanding of relational and dimensional database concepts
Strong understanding of SQL and database programming
Strong understanding of file management concepts, processes, and tools sFTP, PGP Encryption, Sterling
Strong understanding of scheduling/automation concepts, processes, and tools
Tidal
Strong understanding of common IT offerings e.g. Operating systems, storage, backups
Strong understanding of database platforms
SQL Server, Netezza, Oracle, BigQuery, Snowflake
Understanding of cloud technologies and/or big data platforms
AWS, GCP, Azure, Hadoop
Strong knowledge of software engineering and development methodologies, techniques, and tools, including SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile)
Ability to serve as technical point of contact for the solution both internally to Merkle and in interactions directly with the client
Ability to hand off work to other development resources both US and off shore
Excellent communication skills both verbal and written
Ability to present, both verbal and written, to team members, capability members, portfolio members, and clients at the appropriate technological level
Working knowledge of at least one BI tool, such as Tableau, Cognos, Business Objects or Microstrategy. Experience with a campaign tool, such as Adobe Campaign, Unica, Alterian

Key Responsibilities:

Lead CRM platform development programs and roadmapData warehouse architecture and ETL design
Build and maintain SQL procedures and ETL processes
Manage resource allocaiton and release planning
Lead and mentor an implementation team in a matrix organization
Manage hardware infrastructure SLAs, capacity planning, performance and procurement
Design and implement technical vision for client project
Own overall project architecture and technical delivery of multiple solutions
Interact with client on regular basis
Assist in requirements gathering and data analysis as needed
Estimate work effort and assist the Project Manager with task planning and LOE (level of effort) estimates
Provide technical leadership and oversight of a project development team
Review work product of others for compliance with development standards
Provide guidance and mentoring in database marketing development best practices
Conduct design reviews
Audit existiing platform implementations and recommend enhancements

Qualifications:

You'll have the following to succeed in this role:
Bachelor's degree from a four-year college or university in Computer Science or related IT field, or relevant professional experience
Possess the Merkle attributes of being smart, curious, committed to vision, passionate, fun/pleasant, an achiever, and having a sense of urgency
Ability to be a team player