ETL Developer

We are looking for a highly motivated and experienced individual with fresh ideas having passion & great acumen for ETL and data warehousing concepts. Strong working experience in Informatica Power Center, SQL and at least anyone scripting language is must. Good working knowledge in Agile model and should possess strong problem-solving skills and handling critical situations. Must have good knowledge of database systems and should be able to write basic and complex queries and have idea of advanced SQL concepts. Should be familiar with both Windows and UNIX environment.

Key Responsibilities · To interact with the Business, onsite/offshore counterparts to understand business requirement and transforming business rule into technical specifications.

· Responsible for all activities related to the development, implementation of ETL processes for large scale data warehouses using Informatica Power Center 10.5.

· Perform root cause analysis of job failures and propose solutions to perform complex troubleshooting.

· Involved in preparation of unit test cases and executing Unit test plan as well. Responsible for migration of informatica objects from one environment to another.

· Involved in performance tuning of mappings and sql queries for better performance and efficiency.

· Monitoring interfaces and informatica sessions, resolving on-going maintenance issues and bug fixes.

· Documentation for all the activities involved in different phases of development cycle.

· Should be able to identify the areas of improvement and re-engineering scope.

· Participating in discussions with cross commits.

· 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.

· Should be open to learn new technologies/tools.

Required Qualifications

· Bachelor’s degree in computer science, Engineering, or related field; or equivalent work experience.

· 2- 4 years of relevant experience.

· Strong Informatica, IICS and ETL fundamentals.

· Should be experienced in Data Warehouse/Data mart, and OLAP implementations, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation.

· Hands-on experience on a job scheduling tool – preferably with TWS or Tidal.

· Hands-on experience on Power Exchange to create data map from Mainframe copybook.

· Working Experience of Informatica Intelligent Cloud Services (IICS) and Python.

· Basic knowledge of AWS services(S3, Lambda, EMR).

· Basic Knowledge of Mainframe to validate the VSAM files created through ETL.

· Knowledge of dev/test/prod environment code deployment processes.

· Should be able to understand business requirements, create technical specifications and design and implement the same using Integration technologies.

· Should Understand and can interpret, design and code UNIX shell scripts in bash / ksh.

· Conduct ETL workflow and mapping optimization review, troubleshooting and debugging.

· Understand and can interpret database access from Informatica and find optimization opportunities.

· Understand and can interpret scheduling of ETL based batch.

· Provides solutions to the critical issues in ETL (Informatica power center and IICS)

· Provides software support for ETL (Informatica power center and IICS)

· Provides technical assistance for incoming queries and issues related to the software products.

· Maintains operational day-to-day IT functions of software products.

· Performs root cause analysis to determine nature of software environment issues as they arise and provide the permanent fix for the issues.

· Experience with multi-vendor environment and Ability to work in a high-pressured, tight deadline environment.

· Generate innovative ideas and apply them in implementing solutions.

· Flexibility and adaptability towards changing organizational needs.

· Good Communication skills.

· Strong attention to detail and with ability to focus on quality and efficiency.

· Ability to communicate and articulate technical information across various organizational levels.

· Highly innovative problem solver with strong analytical and customer service abilities required.

· High reasoning aptitude and ability to quickly understand complex operating environments.

· Strong thought leadership and motivation with the ability to work independently.

· Ability to work in a diverse multi-national and multi-vendor environment.

· Ability to support working outside of normal business hours to provide after hour or "on-call" support when necessary to solve high profile incidents/problems.

Preferred Qualifications:

· Experience working with Annuity and Insurance products and policy admin systems such as Oracle's OIPA.

· Experience in Mainframe.

· Proven ability to successfully translate client/business needs into software designs.

· Certification on ETL/AWS is an added advantage.

· Should be self-starter and team player in solving issues and mentoring other team members.

· Automation and Continuous improvement support.

· Experience in handling automated code deployments through GIT or other version control tools.

· DevOps, CICD Pipeline knowledge.

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

(2:00p-10:30p)

AWMPO AWMP&S President's Office

Technology