Role: Senior Informatica Consultant Location: Mumbai, India Qualifications: BE/MCA or equivalent Remuneration: Dependent on Experience
The Role is that of a Sr. Developer to work on Informatica for ETL batches/real-time integration where you will be expected to coordinate closely with the functional and business users of Applications to understand Business Intelligence and ETL requirements. You will also get technically involved in the Design and Development of Database objects such as Tables, Views, Index, Stored Procedures, Packages, Functions, Triggers and Integrity Constraints. You will also be expected to perform account management activities as assigned by the Account Manager.
• Application development / support / enhancements / bug-fixing. • Interact with functional and technical representatives of project teams in order to understand business functionalities, technical modules, integration mechanism and data sources. • Prepare test plans and conduct Unit, Integration, Regression, Performance and Functional Testing. • Preparing design documents, building proof of concepts, validating design solution and data modelling. • Preparation of technical specifications, installation and configuration of tools, performance tuning, testing, and deployment. Deploy the tool’s administration functions. • Enhance, customise, troubleshoot, understand & resolve problems related to existing implementation. • Production support for the solution in order to minimise system outages. Investigate and/or resolve issues of inconsistent, inaccurate or missing data. • Control and oversee the timely preparation, update and upkeep of all documents necessary to be maintained within the solution framework, in order to ensure easy availability of information pertaining to the solutions developed and maintained. • Perform/suggest performance monitoring and database tuning Report progress and escalate issues to the Team Lead. • Ensuring that the project and organisation standards are followed during various phases of software development life-cycle and day to day development work. • Perform account management activities as assigned by the account manager.
Skills and Qualifications:
• Experience of multiple end-to-end Informatica projects in solution design and development roles. • Experience on leading database systems Oracle/ Teradata / SQL Server. • Good hands on experience on database queries/procedures and functions. • Experience using a variety of sources like flat files, XML, Queues. • Knowledge on data profiling /Data Quality, Metadata Management will be plus. • Knowledge on new trends like Cloud environment, Hadoop ecosystem will be a plus. • Real-time data processing using web service and REST API will be a plus. • Experience in using JAVA transformation in Informatica. • Contributed in account management activities.