Technical Consultant - Oracle, PL/SQL, Informatica, Fund Accounting

As a Technical Consultant / Technical Architect with Fund Accounting experience, along with Oracle and Informatica expertise, your role will involve working closely with Delivery Managers, System/Business Analysts, and subject matter experts to understand requirements and design solutions. You will be responsible for assisting in effort estimation for new projects/proposals, producing/reviewing technical specifications and unit test cases for interfaces, and developing and implementing standards, procedures, and best practices for data maintenance, reconciliation, and exception management. Your technical leadership skills will be crucial in proposing solutions, estimating projects, and guiding/mentoring juniors in developing solutions on the GFDR platform. Key Responsibilities: - Work with various stakeholders to understand requirements and design solutions - Assist in effort estimation for new projects/proposals - Produce/review technical specifications and unit test cases - Develop and implement standards, procedures, and best practices for data maintenance - Demonstrate technical leadership and propose solutions - Guide/mentor juniors in developing solutions on the GFDR platform Qualifications Required: - Overall 10-12 years of experience in technical leadership in data warehousing and Business Intelligence areas - Strong Oracle SQL/PLSQL and Stored Procedure experience - Experience with Source Control Tools, preferably Clear Case - Good understanding of Data Warehouse, Datamart, and ODS concepts - Experience in UNIX and PERL scripting - Familiarity with standard ETL tools such as Informatica Power Centre - Knowledge of job scheduling tools, with preference to Control-M - Strong data modeling, data normalization, and performance optimization skills - Exposure to fund accounting concepts/systems and master data management is desirable - Strong interpersonal and communication skills - Ability to work closely with cross-functional teams and willingness to engage in both development and production support activities Please note that the company operates in the IT/Computers-Software industry and the role requires a B.E/B.Tech education background. If you are interested in this opportunity, please reach out to jobs@augustainfotech.com for further details.,