United Software Group
Informatica MDM Consultant
United Software Group, Southlake, Texas, United States, 76092
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