Job Description

Data Integration Developers contribute towards the data integration design and development 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.  Data Integration Designers 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.

Responsibilities: 

• Contribute to Data warehouse architecture and ETL design
• Build and maintain SQL procedures and ETL processes
• Leverage the Merkle common frameworks and components
• Comply with development standard and best practices
• Collect and leverage any additional reusable components during a deployment
• Perform development and unit testing
• Mentor other development resources; assist with code reviews

The successful Developer will:

• Deliver high quality code and design documents with minimal supervision
• Be versatile and willing to take on new challenges across different projects and technologies
• Have a high sense of urgency to deliver work on time
• Design solutions to meet client needs
• Support others through leadership / management / mentoring

This position interacts regularly with a wide range of internal Merkle teams (including Quality Assurance, Campaign Management, Business Intelligence, Information Technology, Developers, Project Managers) to support the development and/or ongoing maintenance of the solution. 

Qualifications

• 4-6+ years experience with ETL tool(s) - Talend, Informatica, SSIS, DataStage
• Exceptional understanding of ETL concepts, processes, and tools - Talend, Informatica, SSIS, or DataStage
• 4-6+ years experience with SQL Database(s) - Microsoft SQL Server, Oracle or other major RDBMS
• Significant 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
• Strong understanding of scheduling/automation concepts, processes, and tools 
• Strong knowledge of software engineering and development methodologies, techniques, and tools, including SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile)
• Strong understanding of common IT offerings - e.g. Operating systems, storage, backups
• Knowledge of programing and/or scripting language such as; Python, Java, Bash or Perl
• Bachelor's degree from a four-year college or university in Computer Science or related IT field, or relevant professional experience

PREFERRED SKILLS:

• Experience with cloud technologies AWS, GCP, Azure
• Experience with Database Marketing Solutions
• Experience with a Business Intelligence tool;  Tableau, Power BI, Cognos, Business Objects or Microstrategy.
• Experience with a Campaign tool; Adobe Campaign, Unica, RedPoint

Additional Information

At Merkle, we believe that a diverse environment improves us as a community and as a business. We want to foster an environment of growth, where all ideas and contributions are encouraged. We need this culture of courage to continue to thrive in our fast-paced industry. We embrace differences of opinion. We value diversity of experience and thought, which help us to challenge and define industry-leading solutions, and support our goal of being a great place to work.

All your information will be kept confidential according to EEO guidelines.

THE ANTICIPATED SALARY RANGE FOR THIS POSITION IS $72,000-$100,000. SALARY IS BASED ON A WIDE RANGE OF FACTORS THAT INCLUDE RELEVANT EXPERIENCE, KNOWLEDGE, SKILLS, OTHER JOB-RELATED QUALIFICATIONS, AND GEOGRAPHY.  A range of medical, dental, vision, 401(k) matching, paid time off, and/or other benefits also are available. For more information regarding dentsu benefits, please visit https://dentsubenefitsplus.com/  

#LI-KF1