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