ETL Developer - Informatica (3-6 yrs)

Job Title : Asia-IT Analyst Development ETL Developer

Location : Bangalore, Gurgaon

Experience : 3-6 years

Mandatory Skills : ETL, Informatica Power Centre, PL/SQL, post gre SQL

Job Description :

Responsible for building technical product and ensuring that it works from end-to-end, from low level design to code.

A strong ETL developer who has owned or played a pivotal role in Platform & Technology migration work in the past. He/she is a quick learner who adapts new technologies & frameworks and have good learning attitude. The role will work closely with Canadian IT teams using agile methodologies, delivering ETL solutions.

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.

We require someone with / key experience :

- A Bachelors or masters degree in Computer Science or related field

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

- Domain knowledge of Insurance and Retail Wealth Management.

- Experience in Informatica Intelligent Data Management cloud (IDMC)

- AWS cloud Basics (S3, Lambda, EC2)

- Unix shell scripting

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

- Ability to write complex T-SQL / PL-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.

Good to have :

- Python Scripting

- Kafka

- Understanding of basic Java and Micro service architecture (rest APIs)