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
ANY GRADUATE