We are looking for a ETL Developer to develop, maintain and support applications involving predominately operational and relevant analytical data stores for the ETL Team within the Brokerage Technology domain.
The Informatica platform for the Brokerage team is the major underlying technology component used to support several key assets involving asset classification, asset movement, settlement processing, trade reconciliation and corporate actions reporting for our business team. This position provides an exciting opportunity for the individual to lead, learn and support and end-to-end platform that supports two of the largest datastores in the company. Here, you will be part of an inclusive, collaborative culture that rewards you for your contributions.
Job responsibilities:
- Provide production support for Informatica/AWS suit of applications in 24X7 environment.
- Good understanding of Informatica/AWS environment and able to handle batch recoveries and provide batch support.
- 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.
- Incident Management/Problem management and Change management.
- 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.
- Should be able to identify the areas of improvement and re-engineering scope.
- Helping other team members to resolve their technical issues.
- Mentoring the interns and new joiners.
- Monitor and report issues and work with the required team/vendor for quick resolution.
Required Qualifications:
- 2-8 years of production support experience on Informatica/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 AWS/DataLake concepts. Informatica to Cloud Migration.
- Hands-on expertise in debugging Informatica 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.
- 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 working with US Clients and Business partners.
- Exposure to BFSI domain is a good to have.
- Experience in mainframe technologies will be plus.
- ITSM/Informatica/AWS Certification.
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
Top Skills
What We Do
Ameriprise Financial has helped millions of clients feel confident about their financial futures for more than 125 years. Our network of approximately 10,000 financial advisors* delivers personalized financial advice to help clients reach their goals.
We believe that with the right advisor, the right advice, and the right firm, life can be brilliant.
Ameriprise has corporate locations throughout the U.S. and across the globe, and advisor offices in all 50 states.
Learn how you can build your career at Ameriprise Financial.
*Ameriprise Financial Q2 2020 Statistical Supplement
All content on this page is provided for informational purposes only and should not be used as the sole basis for investment decisions. Ameriprise Financial cannot guarantee future financial results. Investment products are not federally or FDIC insured, are not deposits or obligations of, or guaranteed by, any financial institution, and involve investment risks including possible loss of the entire amount invested.
By clicking on a hyperlink, you may be directed to a non-Ameriprise website. Be aware that the linked site will be subject to rules, regulation, and privacy and security provisions that are separate, and may differ, from Ameriprise Financial.
Investment advisory products and services are made available through Ameriprise Financial Services, LLC., a registered investment adviser.
.JPG)
_2.png)
