ETL Developer

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

Assist in designing, building and maintaining data pipelines using AWS services, PL-SQL, Snowflake, Informatica & MS Fabric. Learn and apply standard techniques, procedures, and criteria to the development life cycle. Through time and exposure, gain specific application and technology knowledge to participate in and contribute to the specification and design development process for ETL components across the portfolio. Create system and operating documentation. Receive technical guidance and day-to-day direction from Sr. Tech Lead.

Key Responsibilities

• Assist in designing, building and maintaining data pipelines using AWS services, PL-SQL, Snowflake, Informatica & MS Fabric

• Ingest, clean and transform data from various sources (structured and semi-structured)

• Collaborate with stakeholders to understand data needs and ensure reliable data delivery

• Write and optimize SQL queries for data extraction and transformation.

• Maintain documentation of data flows, transformations, and architecture

• Orchestrate data pipeline using scheduling tools - Tidal, TWS

• Contribute ideas and effort toward continuous improvement of processes and performance

• Communicate overall status of assigned development tasks to leadership and project team members.

Required Qualifications

• Have bachelor’s or master’s degree in Computer Science, Engineering or other Technical discipline, or equivalent work experience.

• 2-4 years of IT Experience

• Good understanding of ETL/ELT concepts.

• Hands-on experience in creating data pipelines using AWS services: Glue, Athena, S3, Ec2, Lambda etc.

• Strong foundation in PL/SQL, Python & Spark framework, with hands-on experience in building scalable pipelines.

• Strong analytical & data analysis skills.

• Basic understanding of snowflake architecture & query optimization.

• Good communication Skills

• Eagerness to learn and explore new data tools and framework

• Strong academic performance and problem-solving mindset

Preferred Qualifications

• Knowledge of CI/CD concepts & version control like bitbucket (Good to have)

• Experience working with Informatica PowerExchange, Tivoli Work Scheduler (TWS), Mainframe

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(2:00p-10:30p)AWMPO AWMP&S President's OfficeTechnology

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.