Principal Lead- ETL Architect

Job description

About Our Company Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 20 years. We are part of Ameriprise Financial Inc., a US financial planning company headquartered in Minneapolis with a global presence and diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions, and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So, if you're talented, driven and want to work for a strong, ethical company that cares, take the next step and create a career at Ameriprise India LLP. Job Description This Principal Lead ETL Architect provides strategic architecture leadership and direction for enterprise integration capabilities that enable secure, scalable, resilient, and AI-ready movement of data across the organization. The role is responsible for driving the integration strategy, architecture standards, modernization roadmaps, and future-state technology direction supporting cloud, data, digital, and AI platforms. As a senior individual contributor, this position serves as the enterprise integration authority for ETL, file transfer, API, event-driven, middleware, and orchestration capabilities. The architect partners across business, engineering, infrastructure, security, data, and enterprise architecture teams to simplify technology landscapes, reduce technical debt, accelerate cloud adoption, and establish reusable integration capabilities that improve agility and business outcomes. The role also leads technology evaluations, architecture assessments, and modernization initiatives supporting long-term organizational objectives, including cloud transformation, AI enablement, platform rationalization, and enterprise resiliency. Key Responsibilities: Independently perform highly complex architecture, strategy, and technology leadership assignments. Define and maintain enterprise integration architecture strategy, target-state architecture, and multi-year modernization roadmaps. Develop and promote enterprise integration principles, standards, reference architectures, and best practices. Lead architecture assessments, proof-of-concepts, technology evaluations, and strategic recommendations. Drive modernization initiatives involving ETL, file transfer, API-led connectivity, event-driven architectures, cloud-native integration, and AI-enabled workflows. Partner with application, data, cloud, infrastructure, platform, and security teams to align technology roadmaps and investment decisions. Develop future-state integration patterns supporting AWS, Snowflake, Fabric, advanced analytics, and AI-enabled business capabilities. Identify opportunities to reduce technical debt, simplify technology platforms, improve resiliency, and increase operational efficiency. Implement governance processes, technology standards, and architectural guardrails ensuring consistency across portfolios. Serve as an escalation resource and strategic advisor during major incidents, platform transformations, and critical architecture reviews. Collaborate with engineering teams to ensure solution designs align with architectural objectives, enterprise standards, and modernization strategies. Lead vendor evaluations, industry research, market analysis, and strategic technology partnerships. Mentor solution architects and engineers through technical leadership, architecture reviews, and knowledge sharing. Create, maintain, and communicate architecture artifacts, reference models, standards, and roadmaps. Participate in the continual refinement of architecture processes, governance practices, and technology lifecycle management. Continuously develop specialized knowledge and subject matter expertise by remaining current on industry trends, emerging technologies, cloud platforms, integration patterns, and AI-enabled engineering practices. Required Qualifications: Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field; or equivalent work experience. Minimum 12+ years of technology experience with 8+ years in architecture, integration, or platform strategy roles. Demonstrated experience defining enterprise technology strategy, architecture roadmaps, and modernization programs. Strong expertise in enterprise integration architecture, ETL/ELT, middleware, API management, event-driven architecture, managed file transfer, and orchestration technologies. Experience leading large-scale technology transformation and modernization initiatives. Strong analytical, strategic thinking, and problem-solving abilities. Ability to communicate and influence technical and business stakeholders across all organizational levels. Strong thought leadership capabilities with the ability to build consensus and drive organizational alignment. Ability to mentor and guide architects, engineers, and technology teams through influence rather than direct authority. Experience evaluating emerging technologies and translating technical capabilities into business value. Preferred Qualifications: AWS cloud architecture and integration services. Snowflake platform architecture and data integration patterns. Informatica IDMC and PowerCenter modernization experience. Managed File Transfer (MFT) modernization and strategy experience. IBM DataPower, IBM ACE, IBM MQ, CDC, and messaging technologies. API-led connectivity, event streaming, and microservices architecture. Data governance, metadata management, data lineage, and data quality capabilities. AI-enabled software development, intelligent automation, and modern engineering practices. Enterprise Architecture frameworks (TOGAF or equivalent). Financial Services industry experience. Cloud migration and technology rationalization experience. Architecture governance, reference architecture development, and enterprise standards management. In-Office Collaboration We are a client-centric, relationship-based business. Working together, in-person, is foundational to how we achieve results. By fostering a culture of face-to-face collaboration, idea sharing, productivity and personal connection, we deliver for our stakeholders — clients, advisors, employees and shareholders. Our employees work in the office at least three (3) days per week, with flexibility to work from home two (2) days per week. Some roles may require additional in-office time or different in-office expectations, and specific requirements will be discussed during the hiring process. Full-Time/Part-Time Full time Timings (2:00p-10:30p) India Business Unit AWMPO AWMP&S President's Office Job Family Group Technology Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, military status, veteran status, marital status, pregnancy, family status or any other basis prohibited by law. We are committed to fostering an inclusive and accessible recruitment process for individuals with disabilities. If you require a reasonable accommodation to participate in the application or interview process, speak to your recruiter to discuss how we can support you.