Merkle, a dentsu company, is a leading data-driven customer experience management enterprise specializing in delivering unique, personalized customer experiences across platforms and devices. With over 30 years of experience, Merkle partners with Fortune 1000 companies and non-profit organizations to optimize their customer portfolios. Its expertise in data, technology, and analytics enables it to gain insights into consumer behavior, driving hyper-personalized marketing strategies. Merkle's consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions capabilities combine to drive improved marketing results and a competitive edge. With over 14,000 employees, Merkle is headquartered in Columbia, Maryland, with more than 50 additional offices worldwide. Its innovative solutions enable brands to build meaningful customer relationships and enhanced customer experience.

Total Experience : 5 to 7 Years

Must Have Skills: 

• Talend / Informatica/ SSIS / DataStage 
• Microsoft SQL Server / Oracle / other major RDBMS 
• Strong understanding of file management concepts, processes, and tools (sFTP, PGP Encryption etc), scheduling/automation concepts, processes, and tools  
• SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile) 
• Strong understanding  of common IT offerings - e.g. Operating systems, storage, backups 

Good to have Skills:  

• Knowledge of programing and/or scripting language such as: Python, Java, Bash, Perl 
• Understanding of cloud technologies and/or big data platforms - AWS, GCP, Azure, Hadoop 

Key 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 
• Outcomes "The successful Developer - Lead Associate II 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 
• Relationships- The 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.  
• Member of the Development Community  
• Member of designated Capability 
• Member of account/project team(s) 

• 4-6+ years experience with ETL tools such as Talend, Informatica, SSIS and/or DataStage 
• 4-6+ years experience with Microsoft SQL Server, Oracle or other major RDBMS 
• Strong understanding of ETL concepts, processes, and tools - Talend, Informatica, SSIS, or DataStage 
• Strong 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, Perl 
• Understanding of cloud technologies and/or big data platforms - AWS, GCP, Azure, Hadoop 
• Ability to lead and mentor other development resources - both US and off shore 
• Solid  communication skills - both verbal and written