Ameriprise Financial Services, LLC logo
Technical Operations Lead
full-timeNoida

Summary

Location

Noida

Type

full-time

Explore Jobs

About this role

Highly skilled Data Delivery Developer with expertise in SQL, Snowflake, and AWS infrastructure. The ideal candidate will have hands-on experience in complex data migration projects, particularly migrating from SSIS/SQL Server to Snowflake, and a strong understanding of cloud resource management on AWS. Define challenges of large and complex migration projects to best practices and have aptitude of high-level design thinking to build scalable solutions.

Key Responsibilities

  • Design, develop, and maintain scalable data pipelines using Snowflake and AWS services.

  • Write complex and optimized SQL queries for data extraction, transformation, and reporting.

  • Automate data workflows and delivery processes using Python.

  • Collaborate with data architects, analysts, and business stakeholders to understand data requirements.

  • Monitor and troubleshoot data delivery issues and ensure data quality and integrity.

  • Implement best practices for data governance, security, and performance optimization

  • Drive the optimization of technology operations though automation and solution delivery, system/services performance monitoring.

  • Develop, enhance and troubleshoot database objects such as stored procedures, functions, tables and views.

  • Create and maintain data dictionaries, data model and change management documentation.

  • Conduct data profiling to understand data relationship and quality of data through AWS Athena.

  • Participate in all phases of the software development life cycle (SDLC), including requirements, technical design, development, testing and implementation.

Working with column-oriented data storage formats such as Parquet, interactive query service such as Athena/SnowFlake and event-driven computing cloud service Lambda.



Preferred Qualifications

  • 4+ years of strong experience in data delivery projects with strong exposure to writing complex SQL queries, perform SQL optimization and worked on complex data migrations assignments.

  • Experience in SnowFlake, AWS data suite of services like S3, Athena, Glue etc.

  • Experience on AWS infra using CI/CD deployments.

  • Experience with any one of ETL tool like Informatica, SSIS etc..

  • Should have thorough understanding of ITSM process and aptitude to understand the technology infrastructure and cost.

  • Demonstrated ability to manage multiple and varied assignments.

  • Ability to quickly perform critical analysis and use creative approaches for solving complex problems.

  • Strong Academic background.

  • Excellent written and verbal communication skills.

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, veteran status, marital status, family status or any other basis prohibited by law.

About Our Company
Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. 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.

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, veteran status, marital status, family status or any other basis prohibited by law.

Full-Time/Part-Time

Full time

Timings

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology

Other facts

Tech stack
SQL,Snowflake,AWS,Data Migration,Data Pipelines,Python,Data Governance,Data Quality,Database Objects,Data Profiling,SDLC,ETL Tools,CI/CD,Data Extraction,Data Transformation,Reporting

About Ameriprise Financial Services, LLC

At Ameriprise Financial, we have been helping people feel more confident about their financial future for 130 years. With extensive investment advice, asset management and insurance capabilities and a nationwide network of approximately 10,000 financial advisors*, we have the strength and expertise to serve the full range of individual and institutional investors' financial needs.

Ameriprise has corporate locations throughout the U.S. and across the globe, and advisor offices in all 50 states.

Certain hyperlinks within Ameriprise Financial web sites or social media content may hyperlink to third-party content which we believe to be reliable however, we cannot guarantee its accuracy or completeness. For this reason, we do not endorse any linked third-party content, advertising, advice, opinions, recommendations, or other information; it's merely intended to be provided as a general source of information and is not a solicitation to buy or sell any securities, accounts, or strategies. In addition, any linked third-party content should not be used as the sole basis for any investment decisions, nor should it be construed as a recommendation or advice designed to meet the particular needs of an individual investor. Please seek the advice of a financial advisor regarding your particular financial situation.

Investment products are not insured by the FDIC, NCUA or any federal agency, are not deposits or obligations of, or guaranteed by any financial institution, and involve investment risks including possible loss of principal and fluctuation in value.

Investment advisory products and services are made available through Ameriprise Financial Services, LLC, a registered investment adviser.

Securities offered by Ameriprise Financial Services, LLC. Member FINRA and SIPC.

For additional important disclosures on engagement rules, linking to third party content or other risks, please visit: www.ameriprise.com/social

*Ameriprise Financial Q1 2024 Earnings Release.

Team size: 5,001-10,000 employees
LinkedIn: Visit
Industry: Financial Services
Founding Year: 1894

What you'll do

  • The Technical Operations Lead will design, develop, and maintain scalable data pipelines using Snowflake and AWS services while automating data workflows. They will also monitor and troubleshoot data delivery issues to ensure data quality and integrity.

Ready to join Ameriprise Financial Services, LLC?

Take the next step in your career journey

Frequently Asked Questions

What does a Technical Operations Lead do at Ameriprise Financial Services, LLC?

As a Technical Operations Lead at Ameriprise Financial Services, LLC, you will: the Technical Operations Lead will design, develop, and maintain scalable data pipelines using Snowflake and AWS services while automating data workflows. They will also monitor and troubleshoot data delivery issues to ensure data quality and integrity..

Why join Ameriprise Financial Services, LLC as a Technical Operations Lead?

Ameriprise Financial Services, LLC is a leading Financial Services company.

Is the Technical Operations Lead position at Ameriprise Financial Services, LLC remote?

The Technical Operations Lead position at Ameriprise Financial Services, LLC is based in Noida, India. Contact the company through Clera for specific work arrangement details.

How do I apply for the Technical Operations Lead position at Ameriprise Financial Services, LLC?

You can apply for the Technical Operations Lead position at Ameriprise Financial Services, LLC directly through Clera. Click the "Apply Now" button above to start your application. Clera's AI-powered platform will help match your profile with this opportunity and guide you through the application process. You can also learn more about Ameriprise Financial Services, LLC on their website.