Informatica MDM Consultant

Job Description:

•       Interact with business users, source teams, gather requirements and understand business and data requirements

•       Prepare effort estimates and provide input for project planning

•       Convert business requirements into functional & technical specifications

•       Ensure technical specifications meet the business requirements

•       Perform design and code reviews. Present design review in Governance meetings and get approval

•       Work with source systems to get data, setup transfer mechanisms and procedures, confirm SLAs regarding source data

•       Prepare test plan, test case and test execution for unit testing

•       Develop ETL extracts using tools like Informatica, PDO, IDQ and TPT

•       Support user acceptance testing and production deployment.

•       Work with tools such as Informatica PowerCenter, SQL Server, IDQ, MongoDB, Informatic MDM, Mainframe and Automation tools like Informatica DVO.

•       Develop automation scripts using tools like Informatica DVO (ETL tool), shell scripts, SQL scripts and BTEQs as per the technical specifications, best practices and in accordance with customer standards

•       Build ETL extracts, support Schwab during acceptance testing and production deployment, participate in release management meetings and adhere to the process of production installation and metrics reporting.

•       Defines test strategies, test plans, test cycles and carries out detail data level validation using SQL/Informatica DVO tool

•       Understanding of customer’s framework, products, product technology and work practices

•       Preparing complex SQL and HQL scripts for data validation in hive, Teradata and other databases.

•       Provide root cause analysis and recovery method from major/critical system issues.

•       Develop new functions/methods to the reusable components and accelerate automated test development process by leveraging existing automation code assets.

•       Coordinate with product management, scrum teams and support engineers to deliver stable automation suite.

•       Analyze and verify best automated approaches and execute acceptance, integration, installation and system testing and to guarantee adherence of test coverage for meeting end user requirements.

•       Organize regular sync-up with Business partners and the Project team to discuss the enhancements on and its implementation

•       Contribution to technical design documentation (High level and Low-level design specification documents) for end to end business data flow

•       Provide project release sign-off to the stakeholders, for each phase of activity is completes