Job Title:  Consulting-ET&P-Oracle-OAC– Consultant/Sr Consultant –Gurgaon

Essential Skils

• Technical
• Deep knowledge and Experience of using the Informatica Power Centre tool set min 3 yrs.
• Experience in Snowflake
• Experience of Source Control Tools
• Experience of using job scheduling tools such as Control-M
• Experience in UNIX scripting
• Strong SQL or Pl/SQL experience with a minimum of 2 years’ experience
• Experience in Data Warehouse, Datamart and ODS concepts
• Knowledge of data normalisation/OLAP and Oracle performance optimization techniques
• 3 + Yrs Experience of either Oracle or SQL Server and its utilities coupled with experience of UNIX/Windows
• OBIEE knowledge is good to have
• Functional
• 3 + years’ experience of working within financial organisations and broad base business process, application and technology architecture experience.
• Experience with data distribution and access concepts with ability to utilise these concepts in realizing a proper physical model from a conceptual one
• Business facing and ability to work alongside data stewards in systems and the business
• Strong interpersonal, communication and client facing skills
• Ability to work closely with cross functional teams
• Responsibilities
• Work with Technical leads, Business Analysts and other subject matter experts.
• Understand the data model / design and develop the ETL jobs
• Sound technical knowledge on Informatica to take ownership of allocated development activities in terms of working independently.
• Working knowledge on Oracle database to take ownership of the underlying SQLs for the ETL jobs (under guidance of the technical leads)
• Providing the development estimates
• Implement standards, procedures and best practices for data maintenance, reconciliation, and exception management.
• Interact with cross functional teams for coordinating dependencies and deliverables.