Engineering Associate - ETL/Informatica IDMC (3-6 yrs)

Job Title : Engineering Associate Analyst ETL/IDMC Developer

Location : Bangalore, Gurgaon

Experience : 3-6 years

Your scope of work / key responsibilities :

- Able to communicate well with the team for technical arguments and suggest ideas for improvement.

- Collaborate with Designers, Business System Analysts, Application Analysts and Testing specialists to deliver high quality solutions

- Able to prepare high-level and detailed-level designs based on technical/business requirements and defined architectures and maintain documentation

- Have been instrumental in platform migration work and technical migration work in the past and understands the involved intricacies.

- Analyze, define and document requirements for data, workflow, logical processes, interface design, internal and external checks, controls, and outputs

- Ensure information security standards and requirements are incorporated into all solutions

- Stay current with trends in emerging technologies and how they could apply to Sun Life.

Skills Required :

- 3 - 6 years of progressive information technology experience with full application development life cycle.

- Domain knowledge of Insurance and Retail Wealth Management.

- Experience in Informatica Powercenter Development preferably in v 10.4.0 and IDMC DI (IICS)

- Good Understanding of Cloud specially AWS

- Good knowledge and experience of Java1.8 or above.

- Good Knowledge on Python/Pyspark.

- Experience of applying various informatica transformations and different type of sources.

- Ability to write complex SQL and stored procedures, views.

- Experience in SQL Server 2014 and above.

- Exposure to DevOps and API architecture

- Experience in SQL and No-SQL DB like MongoDB etc.

- Good knowledge of coding best practices and should be able to do code review of peer.

- Produce clean, efficient code based on specifications and troubleshoot, debug and upgrade existing software.