JOB DESCRIPTION:

• Gathers requirements, analyzes, creates design documents, and performs impact analysis.
• Knowledge and familiarity of underlying Data Warehousing Concepts and Oracle ERP applications database architecture.
• Develops IDMC(Informatica Data Management Cloud) ETL Objects, Snowflake SQL and Procedures.
• Assists users with problems and resolves issues independently.
• Creates test plans, test cases, test scripts and performs testing.
• Working knowledge of software development and support methodologies.
• Plans and organizes tasks, reports progress to manager.

QUALIFICATIONS:

• Bachelor’s Degree in Computer Science, Engineering or a related field.

KNOWLEDGE & EXPERIENCE:

• Knowledge on SDLC.
• Knowledge on OLAP.
• Knowledge on Data Modeling concepts.
• Knowledge on SQL, PL/SQL, Phyton or Java.
• Knowledge on Snowflake or Oracle.
• Knowledge on ETL / ELT, System Integration Process.

PERSONAL ATTRIBUTES:

• Experience with testing tools, data warehousing.
• Experience with Control-M BMC Scheduling tool.
• Should have excellent attitude/skills with the business users.
• Understanding of functional concepts & flow of Oracle Application Modules.