Job Title: Consultant / Senior Consultant – Data Engineering (Oracle DI, Informatica, SQL/PLSQL)

Experience Required:

- Consultant: 3 to 5 years

- Senior Consultant: 5 to 8 years

Job Summary:

We are looking for experienced Consultants and Senior Consultants with strong expertise in Oracle Data integrator, Informatica, SQL, and PL/SQL to join our dynamic team. The ideal candidates will be responsible for designing, developing, and maintaining robust data pipelines and ensuring data integrity across systems.

Key Responsibilities:

·      Design, develop, and maintain scalable ETL workflows using Informatica.

·      Work with Oracle Data Warehouse solutions and perform data modeling, data transformation, and integration tasks.

·      Write efficient and optimized SQL and PL/SQL queries to manage large-scale datasets.

·      Collaborate with business analysts, architects, and data scientists to gather requirements and translate them into technical specifications.

·      Perform data quality checks, troubleshooting, and performance tuning of data jobs.

·      Document ETL processes, data flows, and technical specifications.

·      Ensure data governance, security, and compliance standards are met.

·      Mentor junior consultants (for Senior Consultant role).

Key Skills:

·      Strong hands-on experience with Oracle databases and PL/SQL programming.

·      Proficient in Informatica PowerCenter / IDQ / IICS and ETL development.

·      Advanced knowledge of SQL, query optimization, and stored procedures.

·      Experience with data warehousing concepts, data modeling, and data integration.

·      Familiarity with version control tools (e.g., Git) and job scheduling tools.

·      Strong analytical, debugging, and problem-solving skills.

·      Excellent communication and documentation abilities.