Data Engineer

Informatica Developer and ODI Data Management

Job Purpose:

• Should be able to troubleshoot errors on Informatica, Oracle Data Integrator (ODI), Teradata, and Hadoop platforms and support applications built on top of it.
• Strong problem-solving knowledge on databases like Hadoop, Teradata & SQL.
• Monitoring jobs/workflows and working with technical teams to derive permanent fixes.
• Hands-on experience in building and troubleshooting Informatica mappings.
• Working experience in handling and managing ETL processes and data warehousing platforms.
• Hands-on experience in writing, debugging, and testing shell scripts.
• Hands-on experience in Teradata utilities like Bteq, Fast Load, Multi Load, TPT.
• Experience in writing, debugging, and testing Hive scripts.
• Hands-on experience in any scheduling tool.
• Ability to logically prioritize tasks and schedule work accordingly.
• Deep understanding of data warehouse concepts.
• Hands-on experience in processes like incident management, problem management, and change management.
• Should be a good team player and individual contributor.
• Should be able to interact with both technical and non-technical users and address their queries.
• Strong analytical and problem-solving skills.
• Good working experience in a support role. Should be flexible for working hours.

EDUCATION

Bachelor Degree / Master in IT/Computer Science / Engineering or related discipline.

EXPERIENCE

6-8 years

JOB SPECIFIC SKILLS & COMPETENCIES REQUIRED

• Must have hands-on experience with Informatica and Oracle Data Integrator.
• SQL (Teradata / Oracle) Intermediate / Advanced.
• Big Data/Hadoop.
• Java/Python.
• UNIX Shell scripting.
• Any scheduling tool.