Data Architect - ETL/Informatica

Key Responsibilities:

• Interface directly with Adobe enterprise customers to gather requirements, design tailored data solutions, and provide architectural recommendations
• Collaborate with both onshore and offshore engineering teams to ensure efficient, high-quality solution delivery
• Produce detailed and clear technical specification documents for data implementation
• Design and structure advanced data models for customer-level analytics and reporting
• Implement customer ID mapping strategies for a unified customer view across data sources
• Automate data movement, cleansing, and transformation using scripting languages and tools
• Lead client calls and manage project deliverables, timelines, and expectations
• Identify and propose innovative solutions to solve complex data challenges and optimize workflows

Requirements:

• 10+ years of experience in data transformation and ETL processes for large, complex datasets
• 5+ years of hands-on experience in data modeling (Relational, Dimensional, Big Data)
• Strong expertise with SQL/NoSQL databases and understanding of data warehouse concepts
• Proficiency with ETL tools (e.g., Informatica, Iil)
• Experience with BI and reporting tools like Tableau and Power BI
• Strong familiarity with customer-centric datasets (CRM, Call Center, Marketing Automation, Web Analytics)
• Excellent communication, time management, and multitasking skills
• Ability to articulate complex technical concepts clearly to technical and non-technical audiences

Education:

• Bachelor's or Master's degree in Computer Science, Data Science, or a related quantitative field