Job Description

AIA-Chennai

Job Summary

We are seeking a Sr. Developer with 7 to 10 years of experience to join our team. The ideal candidate will have expertise in PL/SQL Data Warehousing Concepts Informatica Scheduler ETL SQL Data Integration Informatica PowerCenter and Unix Shell Scripting. This hybrid role requires a strong technical background and the ability to work effectively in a collaborative environment.

Responsibilities

7 to 10 years experience in developing on Informatica Power center and above Oracle SQL PL/SQL Unix scripting.


Enable to design as per the ETL requirements and also help the team to design/develop the code according to the ETL requirements.


Facilitate information gathering sessions and provide data analysis and data mapping.


Identify data sources develop and maintain data architectures constructs data catalog and data decomposition diagrams provide data flow diagrams and documents the process.


Knowledge of databases. Strong SQL knowledge and ability to write and investigate complex queries.


Knowledge of performance tuning is desired.


Excellent interpersonal (verbal and written) communication skills are required


Working in project environments that includes internal external and customer teams


Superior relationship management consultative presentation and communications skills critical thinking and project/time management skills Ability to learn new tools in fast pace.


Very strong knowledge of Application Performance Management (APM) concepts tools and features Knowledge of technologies in a multi-tiered environment


Ability to manage multiple priorities and assess and adjust quickly to changing priorities.


Develop solution in highly demanding environment and provide hands on guidance to other team members.


Head complex ETL requirements and design.


Implement an Informatica based ETL solution fulfilling stringent performance requirements.


Assess requirements for completeness and accuracy.


Determine if requirements are actionable for ETL team.