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

Essential SkilsTechnicalDeep knowledge and Experience of using the Informatica Power Centre tool set min 3 yrs.Experience in SnowflakeExperience of Source Control ToolsExperience of using job scheduling tools such as Control-MExperience in UNIX scriptingStrong SQL or Pl/SQL experience with a minimum of 2 years experienceExperience in Data Warehouse, Datamart and ODS conceptsKnowledge of data normalisation/OLAP and Oracle performance optimization techniques3 + Yrs Experience of either Oracle or SQL Server and its utilities coupled with experience of UNIX/WindowsOBIEE knowledge is good to haveFunctional3 + 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 oneBusiness facing and ability to work alongside data stewards in systems and the businessStrong interpersonal, communication and client facing skillsAbility to work closely with cross functional teamsResponsibilitiesWork with Technical leads, Business Analysts and other subject matter experts.Understand the data model / design and develop the ETL jobsSound 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 estimatesImplement standards, procedures and best practices for data maintenance, reconciliation, and exception management.Interact with cross functional teams for coordinating dependencies and deliverables.