United Software Group
Role - Informatica MDM Consultant
Location:
Southlake, TX
(Day 1 Onsite and 5 Days WFO)
Yrs. of experience: 8+ Yrs.
Mode of employment: Full-Time
Salary: $120K (Including QPLC)
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
Thanks & Regards,
Patel
Direct: 614-588-8528 / 614-495-9222 Ext: 346 | Fax: 866-764-1148
E-mail:
patelb@usgrpinc.com
Location:
Southlake, TX
(Day 1 Onsite and 5 Days WFO)
Yrs. of experience: 8+ Yrs.
Mode of employment: Full-Time
Salary: $120K (Including QPLC)
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
Thanks & Regards,
Patel
Direct: 614-588-8528 / 614-495-9222 Ext: 346 | Fax: 866-764-1148
E-mail:
patelb@usgrpinc.com