Database engineer Jobs in Minneapolis, MN

Description

Ameriprise 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 Responsibilities

• Lead the team to provide production support for Informatica/IDMC/Python/AWS suit of 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 Qualifications

• Bachelor's degree in Computer Science, Computer Engineering or a related field.

• 10 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 Qualifications

• Experience in mainframe technologies will be plus.

• Experience on Informatica, AWS, IDMC.

• Knowledge in the Advice & Wealth Management business

Visa Sponsorship

Applicants 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 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 four (4) days per week, with flexibility to work from home one (1) day 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 Salary

The estimated base salary for this role is $100,000 - $145,000 / 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 insurance.

Full-Time/Part-Time

Full time

Exempt/Non-Exempt

Exempt

Job Family Group

Technology

Line of Business

TECH Technology