Operations Engineer

About Our CompanyWe’re a diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. Our team of 22,000 people across 19 countries, serves more than 3.5 million individual, small business and institutional clients. We are a longstanding leader in financial planning and advice, a global asset manager and an insurer. Our unwavering focus on our clients and strong financial foundation connects each of our unique businesses – Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance and Annuities. Here, we foster meaningful careers, invest in the future, and make a difference for clients, institutions and communities around the world.Job DescriptionAmeriprise Financial, Inc. seeks an Operations Engineer in Minneapolis, MN to support the ETL technologies production environment by proactively monitoring and quickly responding to batch incidents across multiple technologies within the technical area of expertise.Key ResponsibilitiesLead the team to provide production support for Informatica/IDMC/Python/AWS suit of applications and Brokerage Distributed/Mainframe applications in 24X7 environment. Good understanding of Informatica/IDMC/Python and AWS environment and able to handle batch recoveries and provide batch support.Good understanding of JCL, CICS, IMS, DB2, and storage technologies and work in resolving the issues.Assess & recommend solutions for permanent fixes to improve application stability and resiliency. Ability to handle production incident bridge calls for P1 and high priority P2 incidents.Strong analytical capability to do independent ticket analysis and resolution. Drive team to work on Incident Management/Problem management and Change management and provide the weekly status to the leadership.Ability to do the Root cause analysis, recap the issues and problem in an email and communicate to all stakeholders and cross commit teams.Ability to drive production issues bridges and able to work across the teams to collate the impacts and send leadership communications.Propose solutions to perform complex troubleshooting and help team members whenever they are getting struck with issues.Should be able to identify the areas of improvement and re-engineering scope.Mentoring the interns and new joiners.Collaborate with vendor and contractor partners to develop and implement detailed design, configuration, and engineering strategies.Provide solutions to resolve issues and incidents while remaining focused on security, up-time, and performance.Provide troubleshooting and resolution to complex problems and issues.Required QualificationsBachelor's degree in Computer Science, Computer Engineering or a related field.5-7 years of relevant experience required.5-7 years of production support experience on Informatica/Python/AWS Technologies and applications.Must have good understanding and technical knowledge on Informatica architecture/client components such as Workflow Manager, Mapping Designer, workflow monitor and Repo manager.Excellent knowledge on Informatica/IDMC/AWS/Python concepts. Knowledge on AWS services such as IAM, SNS, SQS, Lambda, EMR, Lake Formation, AWS Step Function, Athena, and EC2 is required.Hands-on expertise in debugging Informatica/IDMC ETL Mapping to narrow down the Issue.Hands-on experience in ETL transformation such as lookup/joiners/source qualifier/normalizer.Hands-on experience in dealing with various types of sources such as Flat files/Mainframes/XML files and Databases.Hands-on experience in resolving the Mainframe file issues like (Dataset unavailable or locked, Space issue, CPU Utilization, JCL errors).Experience on AWS environment, Data Pipelines, RDS, Reporting tools.Hands-on experience in Unix scripting/file operations. Strong knowledge of SQL/PL-SQL and oracle Databases. Able to debug complex queries.Good understanding on scheduling tool such as TWS/TIDAL/Others.Worked at least 4 years on ServiceNow for application incident management, problem management in a 24*7 model.Strong communication skills both written and verbal with the ability to follow the processes.Preferred QualificationsExperience in mainframe technologies will be plus.Experience on Informatica, AWS, IDMC.Knowledge in the Advice & Wealth Management business.Visa SponsorshipApplicants must have a valid work authorization that does not now, or in the future, require visa sponsorship for employment in the United States (e.g., H-1B, F-1 CPT, F-1 OPT, TN).In-Office CollaborationWe 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 four (4) days per week, with flexibility to work from home one (1) 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.Base Pay SalaryThe estimated base salary for this role is $107,000 - $147,100 a year. We have a pay-for performance compensation philosophy. Your initial total compensation may vary based on job-related knowledge, skills, experience, and geographical work location. In addition, most of our roles are eligible for variable pay in the form of bonus, commissions, and/or long-term incentives depending on the role. We also have a competitive and comprehensive benefits program that supports all aspects of your health and well-being, including but not limited to vacation time, sick time, 401(k), and health, dental and life insurances.Full-Time/Part-TimeFull timeExempt/Non-ExemptExemptJob Family GroupTechnologyLine of Business TECH TechnologyAmeriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, military status, veteran status, genetic information, citizenship, disability status, marital status, 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.SummaryLocation: Minneapolis, MinnesotaType: Full time