Informatica Lead

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