Informatica MDM Consultant - Southlake, United States - SRI Tech Solutions Inc.

    SRI Tech Solutions Inc.
    SRI Tech Solutions Inc. Southlake, United States

    4 weeks ago

    Default job background
    Description

    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